| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to merge monthly workbooks into a quarterly workbook?? | Excel Worksheet Functions | |||
| macro | Excel Discussion (Misc queries) | |||
| Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
| Aways open workbook on sheet 1 ??? | Excel Discussion (Misc queries) | |||
| How do I open a workbook in a specific sheet | Excel Discussion (Misc queries) | |||
Linear Mode
