Open workbook to same page every time?

R

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.
 
B

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)
 
P

Patrick Fredin

Hi,

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

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

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.
 
Top