Default Sheet in Worksheet

[francesca.foster]

Is there a way of setting a designated sheet to open first
each time you open your worksheet so no matter what the
last sheet was that someone worked on, the designated
default sheet, always appears first.

 

[Norman Harker]

Hi Francesca!

Try the following in the ThisWorkbook Module:

Private Sub Workbook_Open()
Application.Goto Reference:="StartPoint", Scroll:=True
End Sub

Now just name the cell that you want to be top left StartPoint
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi

you can sue the workbook_open event:
Private Sub Workbook_Open()
Worksheets("Sheet2").Activate
End Sub

will always activate sheet2 at startup
HTH
Frank