| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open WB on spesific sheet each time (Excel 2003)
I have a WB with lots of sheets where one is a navigation sheet. I would like
the workbook to always open on this sheet no matter what sheet is active when saving the WB. Than you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open WB on spesific sheet each time (Excel 2003)
Place the below code in Open event. Rename the 'sheet1' to your navigation
sheet name Private Sub Workbook_Open() Sheets("Sheet1").Activate End Sub If you are new to VBE and macros , set the Security level to low/medium in (Tools|Macro|Security). From workbook launch VBE using short-key Alt+F11. From the left tree view double click 'This Workbook' and copy the above code. Save and get back to workbook.. If this post helps click Yes --------------- Jacob Skaria "Espen Rostad" wrote: I have a WB with lots of sheets where one is a navigation sheet. I would like the workbook to always open on this sheet no matter what sheet is active when saving the WB. Than you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open WB on spesific sheet each time (Excel 2003)
Thank you again Jacob. That worked perfectly!
Jacob Skaria skrev: |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Open WB on spesific sheet each time (Excel 2003)
Can I also lead to a spesific cell?
Jacob Skaria skrev: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| verify if spesific sheet exist | Excel Discussion (Misc queries) | |||
| How to get exact hours above a spesific time? | Excel Discussion (Misc queries) | |||
| How to find number of hours past a spesific time | Excel Discussion (Misc queries) | |||
| Why with Excel Xp takes time to open and in 2003 fast? | Excel Discussion (Misc queries) | |||
| Why does Excel 2003 open on 3rd tab of workbook every time, not l. | Excel Worksheet Functions | |||
![Espen Rostad[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
