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