Paste the following code in the workbook code page:

'-----------------------------------
Private Sub Workbook_Open()
Sheets("User Select").Activate
End Sub
'-----------------------------------

HTH
--
AP

"SamuelT" a écrit
dans le message de news:
...

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