Startup worksheet

  • Thread starter Thread starter Nevets
  • Start date Start date
N

Nevets

This may be a rediculously simple question, but I can't find an answer
anywhere else. How do I choose which sheet will be the one that displays
when a workbook is opened? I have created a template workbook with four
sheets, and I'd like it to always open on one of the four sheets.
 
If SheetX is active at the time when the workbook was last saved, then
SheetX will be the sheet that is displayed on opening.

You can override this with an event macro such as:

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
End Sub

Copy this code; right click the Excel logo next to "File" on the menu;
select View Code; and paste the code. Just alter "Sheet1" to suit your need.
Users will need to have macros enabled.

best wishes

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
 
Back
Top