Always open in the same place...
 

Hi all

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

Can anyone suggest a means of achieving this

TIA

Samuel

--
Samuel
-----------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...fo&userid=2750
View this thread: http://www.excelforum.com/showthread.php?threadid=54578

Always open in the same place...
 

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


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

Always open in the same place...
 

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

Always open in the same place...
 

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

Always open in the same place...
 

Thanks Richard - that worked a treat :)


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