Open On Certain Sheet
Jun 2, 2006
I have a workbook with several worksheets. I have a macro which runs on opening (to cause a userform to open).
however I am now requiring the workbook to open on a required sheet (still with the userform opening too.
I use the code to open the userform (Module 9)
Option Explicit
Sub ShowMenu()
'
' frmBranchSales.Show
End Sub
On the sheet I want to open to, I have the
Private Sub Workbook_Open()
Sheets("Commission").Select
End Sub
However it will not open.
View 5 Replies
ADVERTISEMENT
Oct 27, 2008
EXAMPLE: Complete Sheet called "Day1". When day1 is complete you click on button and it then copies itself and creates and renames new sheet to "Day2", then when "Day2" is complete you click on button and it then copies itself and creates and renames new sheet to "Day3", and so on and so forth to "Day30".
View 9 Replies
View Related
Feb 5, 2012
I am trying to prepare a Worksheet that has an initial sheet which is a summary of all sheets, information on individuals and totals etc. This summary sheet will be added to over time. I would like it so that when I enter the details of a new individual on the summary sheet a new sheet is opened following a template with the details already filled in for that individual, and for the new sheet to be named with the individual's name. Ideally the new sheet would open automatically once the info has been entered, either that or a button to open the new sheet,
View 3 Replies
View Related
Apr 1, 2014
I am using the following code to open a sheet from an object on another sheet within the workbook and it works fine. I would like to refine it to open the sheet and view the last row with data. The sheet contains a table called "WeightTBL" wit over 500 rows. I want it to open to the last row in the table.
[Code].....
I need to change the line Range("C2").Select to something else...
View 2 Replies
View Related
May 8, 2014
I have been reviewing various methods of doing this and I had one that worked and for some reason it has now stoped?
The Code is:
Sheets("BCDashbd").Select
Sheets("Main Dshbd").Visible = True
Sheets("BCDashbd").Select
ActiveWindow.SelectedSheets.Visible = False
This is activated by using a button on the BCDashbd Page. I want it to hide the BCDashboard sheet and Unhide the Main DshBd Sheet. Currently it opens the Main Dshbd sheet but does not hide the BCDshboard Sheet?
What have I missed?
View 3 Replies
View Related
Aug 20, 2014
I have below code, which copy the sheet from different workbook and paste it in current book. How to ensure that below code find Sheet name "Create Positions" and copy that sheet data only and not other sheet?
[Code] .....
View 1 Replies
View Related
Aug 14, 2007
I'm just starting to learn about using macros in buttons to send me to another sheet within the workbook, but what I now want to do is have a drop-down list that when I click on one of the entities in the drop-down list, I'm sent to that particular sheet
View 9 Replies
View Related
Mar 10, 2009
How do I get a workbook to open with a selected sheet visible, or preferably all hidden? I already have a userform that opens upon opening the workbook that the user 'Enters' the workbook with.
My untidy method would have been to use an If -Then statement for each sheet in the Private Sub Workbook_Open. Is there a neater way of doing it?
View 6 Replies
View Related
Aug 12, 2009
Say im in sheet 1 at B2. Am looking to create a button so when I press it a small window opens and displays the data that is it sheet 2 (which is just 2 columns of a list of products and price.
Then I for example double click on a product and it will be added in the current cell.
View 14 Replies
View Related
Jan 26, 2010
On a command button in a userform, I have this code to open another workbook:
View 2 Replies
View Related
Jan 16, 2007
I am working on code to move worksheets to existing workbooks based on the filename in a cell value. Here are my questions...
1.Does the destination workbook need to be opened before I can move a worksheet there?
2. How can I write the code to take the sheet name which is also in column A of "Data" sheet and the path or destination to move the sheet name to the path that is in column B of the "Data" sheet?
3.Can someone help me with the code?
All the worksheet names and copy destination is in the "Data" sheet. Here is what I have for code...
_____________________________________________________
Dim wbBook As Workbook
Dim qsSheet As Worksheet
Dim dsSheet As Worksheet
Dim wsSheet As Worksheet
Dim dpStart As Range, dpData As Range
Dim ptStart As Range, ptData As Range
Set wbBook = ThisWorkbook
Set qsSheet = wbBook.Worksheets("Query")
Set dsSheet = wbBook.Worksheets("Data")
Set wsSheet = wbBook.Worksheets
With dsSheet
Set dpStart = .Range("A2")
Set dpData = .Range(.Range("A2"), .Range("A65536").End(xlUp))
Set ptStart = .Range("B2")
Set ptData = .Range(.Range("B2"), .Range("B65536").End(xlUp))
End With
For Each wsSheet In ThisWorkbook.Worksheets
If Not wsSheet.Name = "Data" And Not wsSheet.Name = "Query" Then
wsSheet.Copy
View 9 Replies
View Related
Oct 30, 2009
I have a WB with 31 sheets, each dated 1st to 31st and currently hidden.
I have been trying to write a VBA code that would open a sheet based on todays date... so if today is the 2nd of Nov it would unhide the sheet 2nd, I would also like it to check if a sheet dated 1st is visable, and if it is, hide it.
The date for the sheet to hide would I think need to be relative... but I don't know how to get it right.
View 9 Replies
View Related
Jul 10, 2014
How do I determine if AutoFilter is turned on when I open a sheet? I tried FilterMode with no luck.
HTML Code:
Sub macro2()
Dim t As Boolean
s = ActiveWorkbook.Name
t = Worksheets("SO_PO_14").FilterMode
End Sub
The FilterMode call always return False,
View 2 Replies
View Related
Aug 23, 2013
I have a workbook including several sheets.
I'd like to hide all worksheets and in the excel there is only one visible sheet which is Navigation Page. I want to add several buttons on this sheet and each button will be clicked to call the other sheets.
For example, there is a sheet called Sales_Approval_Form and I'd like to add a button on navigation page called Sales Approval Form and when the user clicks the button the sheet will be open for entering data.
View 12 Replies
View Related
Feb 24, 2014
I've got this function where you can select from a list of names, and when you press go it unhides the sheet and goes to it, problem with that was after closing the sheet it was no longer hidden. So now, I have
[Code]......
So when you press go, it unhides the sheet, goes to it, and hides it again, but then the sheet is hidden it pushes the user back to the page they was on, so it would appear you can't have a hidden sheet open.
Is there a way for excel to determine when the sheet has been closed, to be able to hide it when the user navigates away?
View 6 Replies
View Related
Dec 6, 2008
I am trying to create an event macro that would deactivate column and row headers when the workbook is launched and activate a sheet. i am not managing to do this,
View 2 Replies
View Related
Mar 26, 2009
I recorded a Macro to open a specific sheet and it works fine however I want to go to the next step and have the sheet open to a specified column in the sheet based on the column in cell 'H2' on the current sheet.
View 13 Replies
View Related
Jan 21, 2012
I'm trying to open a web link from my excel sheet in Mozilla firefox. But each time I try to open the link it opens in Internet explorer eventhough I've set mozilla as my default browser.
How could I write a code that would open the link in mozilla firefox.
View 4 Replies
View Related
May 11, 2012
I'm trying to do something which I believe is simple but my lack of VBA knowledge is getting in the way. How do I open 2 workbooks then copy a sheet from 1 workbook to another?
I can get the workbooks open just can't copy the sheet across? I get a run time error 9, subscript out of range message on copy sheets code
Code:
Private Sub CommandButton1_Click()
'locate file via range and open the document'
[Code]......
View 2 Replies
View Related
Sep 5, 2012
create this macro.
I am trying here is,
I have open workbook with command button, by pressing it it should do followings
Copy Range ("A1 : C20")
Open a closed workbook
Add Sheet with date format
Paste the range in Created sheet in A1 to C20 column.
View 4 Replies
View Related
Nov 25, 2013
I have this workbook in which each sheet refers to a month in a specific year (e.g. Jan12, Nov13), plus an "overall" sheet where I would like to, among other stuff, create a button that would lead me to the sheet refering to "today's month".
Although I know how to create a "static" macro that leads me to a particular sheet, I don't know how to create one in which the sheet it refers to is changing every single month.
(Note: I'm using Win7, MSExcel 2010)
View 6 Replies
View Related
Feb 2, 2014
Am using a VB for auto transpose values to sheet 2 from sheet 1 in MS EXCEL 2007.
What code to add to the already existing VB so that if someone is using the sheet and leaving the cell in E12, for example, and saving it, then the next user should find it again on A3 but not on E12.
The sheet should always open on A3..
View 4 Replies
View Related
Jul 8, 2014
I want open particular sheet in a workbook after showing warning Message .
View 5 Replies
View Related
Dec 13, 2006
I have a file with various tabs One of them is called "database"
What I would like is for the "DATA"/"FORM" to automatically open when the sheet is clicked on
View 9 Replies
View Related
Feb 28, 2007
I'd like to make a template so that when it is opened the previous month name is inserted in the sheet name. The reason I want to use previous month is that normally this report is created in the month following the month being reported. So it is opened, months are updated, then the user saves as xls. Ideally I guess sheet would not have the month on the template.
The name of the sheets are shortened months like "Dec Results Bob" and there are 8 of these.
I can tell it might start:
Private Sub Workbook_Open() (or would .xlt be the same?)
but that's about it. I made a macro of renaming sheet but that didn't really tell me if I could insert the Month there.
View 9 Replies
View Related
May 15, 2007
If i have a sheet with multiple tabs can I somehow make excel open that file on a particular tab rather than the tab that the user was on when they saved/closed it.
View 9 Replies
View Related
Nov 20, 2009
I want the work book to open on the "Weekly Report" sheet.
I have this code, but keep getting a subscript error.
Private Sub Workbook_Open()
Sheets("Weekly Report").Select
End Sub
View 9 Replies
View Related
Feb 10, 2010
my sheet tabs sometimes disappears when I open excel. I know you can go through the start button and the advanced option to display the sheet tabs. Is there code I can incorporate so that on the opening of the excel file after the splash screen runs its course, the sheet tabs are displayed.
View 9 Replies
View Related
Sep 2, 2006
I have exported some raw data into excel. On another sheet in the same workbook I have a formatted sheet which will be my final report. I would like to know how I can copy data from one sheet to another via VBA code using the auto_open() function.
View 2 Replies
View Related
Jan 17, 2007
I am trying to create a sheet with 'buttons' on, a bit like a 'linked table of contents', that will take the user to individual sheets (as opposed to clicking on the sheet tabs). I can see how to place Command buttons on a sheet (in this case Sheet1), but I think I need help with the code to make the buttons function as I envisage. Is this in the scope of help via this forum?
View 9 Replies
View Related