opening a workbook on a cetain page

  • Thread starter Thread starter electric_d
  • Start date Start date
E

electric_d

I have a worksheet as a main menu. I want this sheet to come up first
when I open up my workbook. I realise that the worksheet you are on
when its last saved is displayed first, I just wanted to know to
overlook this and have a perminant 'first page' no matter what sheet
you save last on.
 
You need VBA to do this. Use a macro like the following:

Sub Auto_Open()
Worksheets("TheSheet").Select
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hi
put the following code in your workbook module:
Private Sub Workbook_Open()
Worksheets("your_main_menu_sheet").Activate
End Sub

and replace the sheetname
Frank
 
Back
Top