Open WB on spesific sheet each time (Excel 2003)

[Espen Rostad]

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

 

[Jacob Skaria]

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

 

[Espen Rostad]

Thank you again Jacob. That worked perfectly!

Jacob Skaria skrev:

 

[Espen Rostad]

Can I also lead to a spesific cell?

Jacob Skaria skrev: