Hi Samuel,

Try:

'=============
Private Sub Workbook_Open()
Me.Sheets("Sheet1").Activate
End Sub
'<<=============

Change Sheet1 to the name of your front page sheet.

This is workbook event code and should be pasted into the workbook's
ThisWorkbook module *not* a standard module or a sheet module:

Right-click the Excel icon on the worksheet
(or the icon to the left of the File menu if your workbook is maximised)
Select 'View Code' from the menu and paste the code.
Alt-F11 to return to Excel.


---
Regards,
Norman


"SamuelT" wrote in
message ...

Hi all,

I wonder if anyone can help. I have a spreadsheet that a number of
different people are using. I have a 'front page' that has a number of
buttons that the various users press to take them to specific
information. What I'd like is for every time someone opens the document
it always takes them to this front page worksheet (it's called 'User
Select') rather than the last place it was saved.

Can anyone suggest a means of achieving this?

TIA,

SamuelT


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile:
http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=545788