Open WB on spesific sheet each time (Excel 2003)

  • Thread starter Thread starter Espen Rostad
  • Start date Start date
E

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
 
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
 
Back
Top