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

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

Open WB on spesific sheet each time (Excel 2003)
 

Thank you again Jacob. That worked perfectly!

Jacob Skaria skrev:

Open WB on spesific sheet each time (Excel 2003)
 

Can I also lead to a spesific cell?

Jacob Skaria skrev: