How do I make excel startup in a specific sheet?
 

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


--
Siggi
------------------------------------------------------------------------
Siggi's Profile: http://www.excelforum.com/member.php...o&userid=20013
View this thread: http://www.excelforum.com/showthread...hreadid=346003

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

"Siggi" wrote in message
...

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


--
Siggi
------------------------------------------------------------------------
Siggi's Profile:
http://www.excelforum.com/member.php...o&userid=20013
View this thread: http://www.excelforum.com/showthread...hreadid=346003

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

"Siggi" wrote in message
...

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


--
Siggi
------------------------------------------------------------------------
Siggi's Profile:
http://www.excelforum.com/member.php...o&userid=20013
View this thread: http://www.excelforum.com/showthread...hreadid=346003