Starting a workbook

  • Thread starter Thread starter Dan D.
  • Start date Start date
D

Dan D.

Hello all,

I have a workbook with multiple worksheets. When I start
thie workbook, I want sheet 1 to be the sheet that
opens. How can I do this?

Thanks
 
Hi Dan

Right click on the Excel icon next to File in the menubar
And choose View code

You are now in the Thisworkbook module
Paste the Event in this place
Alt-Q to go back to Excel
Save your file and close it

You can use this in the Thisworkbook module to go to a specific sheet

Private Sub Workbook_Open()
Sheets("Sheet1").Select
End Sub

Or you can use this in the Thisworkbook module to go to a specific sheet/cell

Private Sub Workbook_Open()
Application.Goto Reference:=Worksheets("Sheet1").Range("A100"), _
scroll:=True
End Sub
 
Back
Top