opening a workbook on a cetain page

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.
 
C

Chip Pearson

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
 
F

Frank Kabel

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
 
Top