Open workbook to same page every time?

[RJQMAN]

Is it possible to put some code in my workbook so that every time it is
opened it opens to one specific page (worksheet) no matter what page
the workbook was on when it was closed? I have six pages (worksheets).
Thanks in advance.

 

[Bob Phillips]

Private Sub Workbook_Open()
Worksheets("Sheet3").Activate
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Hi,

In the module of the object "ThisWorkbook" you can add this code :

Private Sub Workbook_Open()
Me.Worksheets("MySheet").Activate
End Sub

 

[RJQMAN]

That is truly amazing. I have read and re-read the four textbooks I
have for two days, and you can answer the questing in 3 lines of code
in 5 minutes. It works perfectly. Many, many thanks. You are
appreciated.