If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
auto open specific worksheet
How can I set a workbook to automatically open to the
specific worksheet I want when I open the workbook? |
#2
|
|||
|
|||
auto open specific worksheet
The workbook will open up where you were when it was last saved, so, select
the worksheet and even the cell where you want to be when you open the workbook, and save it. Close it and re-open it, it should take you to the same spot you were when you saved and closed it. hth, Dan wrote in message ... How can I set a workbook to automatically open to the specific worksheet I want when I open the workbook? |
#3
|
|||
|
|||
auto open specific worksheet
You can paste the following code in the workbook: Private Sub Workbook_Open() Sheets("Sheet2").Select Range("A1").Select End Sub Replace Sheet2 and A1 as needed. To access the workbokk's code right-click a sheet ta and select 'View Code'. Once the VB editor opens select the 'This Workbook' option that appears under your file name and paste the code in the window that opens to the right. Close the editor and go back to excel. Save the workbook and colse, it will open to that Sheet next time. Note: Some security settings might disable macros automaticaly. Regards, Felipe -----Original Message----- How can I set a workbook to automatically open to the specific worksheet I want when I open the workbook? . |
Thread Tools | |
Display Modes | |
|
|