Start-up worksheet!?

N

Neo1

Hello basically I would, each time i open my spreadsheet model for the
worksheet i wont to pop up, and from there i can navigate easily to the
other worksheets by buttons, how can i make a worksheet to pop up like
this everytime i open the file....?

Thanks
From John
 
B

Bob Phillips

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


This is workbook event code.
To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code from the menu, and paste the code

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
N

Neo1

Thanks a lot, there wouldnt by any chance be a way without inputtin
code, such as in Microsoft Access which you use the menu at the top t
just add what you want to appear when you run the file..?

Thanks
From Joh
 
Top