Startup in specific worksheet

[mmmarty]

I have 5 worksheets in 1 workbook.
Is it possible to open the workbook in worksheet #3 each time.? Regardless of which sheet was open when saved last.

 

[VoG]

Right click the Excel logo just to the left of File on the menu bar > View code.

Paste in

Private Sub Workbook_Open()
Application.Goto reference:=Sheets("Sheet3").Range("A1"), scroll:=True
End Sub

Close the code window, save and close the workbook then try opening it.

 

[wisewood]

I think this should work, assuming Sheet # 3 is called Sheet3.

Private Sub Workbook_Open()
     
    With Application
         'disable the ESC key
        .EnableCancelKey = xlDisabled
        .ScreenUpdating = False
         
        Sheets("Sheet3").Cells(1, 1).Select
         
        .ScreenUpdating = True
         're-enable ESC key
        .EnableCancelKey = xlInterrupt
    End With
     
End Sub