Start-up worksheet!?

[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

[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)

"Neo1" <Neo1.23lpta_1140562200.6674@excelforum-nospam.com> wrote in message
news:Neo1.23lpta_1140562200.6674@excelforum-nospam.com...
>
> 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
>
>
> --
> Neo1
> ------------------------------------------------------------------------
> Neo1's Profile:
http://www.excelforum.com/member.php...o&userid=30329
> View this thread: http://www.excelforum.com/showthread...hreadid=515098
>

[Neo1]

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

Thanks
From John