Always open in the same place...

[SamuelT]

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

[Richard Schollar]

Hi Samuel

You need to place the following code in the ThisWorkbook module of the workbook:


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

Which will automatically activate the given sheet when the workbook is opened.

Hope this helps!

Richard

[Ardus Petus]

Paste the following code in the workbook code page:

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

HTH
--
AP

"SamuelT" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> 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
>

[SamuelT]

Thanks Richard - that worked a treat

[Norman Jones]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>