View Single Post
  #3   Report Post  
James
 
Posts: n/a
Default

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