Default Sheet in Worksheet

  • Thread starter Thread starter francesca.foster
  • Start date Start date
F

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