Go to worksheet upon opening

  • Thread starter Thread starter SageOne
  • Start date Start date
S

SageOne

Is there a way to have the same worksheet pop up every time the excel file is
opened......
 
hi
yes.
Private Sub Workbook_Open()
Sheets("Sheet1").Activate
Range("A1").Select
End Sub

adjust the sheet name and range to suit
this is workbook code.
press ALT+F11. this will bring up the vb editor.
at the far right, expand your project(file). double click ThisWorkbook.
in the code window(far right), click the right drop down and select Workbook.
the workbook open event should default in (see above).
paste the two line between workbook open and end sub above between workbook
open and end sub in your vb editor. close the vb window and save the file.
next time you open the file the file, excel will goto the sheet and range
you specify.

Regards
FSt1
 
Back
Top