How do I make excel startup in a specific sheet?

[Siggi]

Hi,

could anyone of you help me figuring out, how I make sure that the user
of a workbook, always enters the same sheet ( a frontpage)??

...I have a workbook with several users, and I would like them to
always start on the frontpage sheet! No matter where the former user
saved the file.

Thanks,
Siggi

 

[Paul B]

Siggi, you could use the workbook open event, as long as the workbook is
opened with macro enabled it will go to you sheet

Private Sub Workbook_Open()
Sheets("a frontpage").Select
Range("A1").Select

End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[James]

Hi - you could use a macro to do this, copy the following to the This
Workbook module in the vb editor

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

However this will only work if the users always select Enable Macros when
opening spreadsheets

James