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
|
|||
|
|||
How can I set a workbook to open always with a certain sheet I wan
I'd like to have the workbook set to open alway with a certain page, no
matter where I was last time working on it, but it should open always with a certain page I want |
#2
|
|||
|
|||
How can I set a workbook to open always with a certain sheet I wan
Shariq
Use a Workbook_Open() event in the workbook Private Sub Workbook_Open() Worksheets("Sheet1").Activate Range("A1").Select End Sub To implement, right-click the small Excel icon for the workbook and select view code. Paste here and save -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Shariq" wrote in message ... I'd like to have the workbook set to open alway with a certain page, no matter where I was last time working on it, but it should open always with a certain page I want |
Thread Tools | |
Display Modes | |
|
|