Tips & Tricks 122 – Always Open a Specific Worksheet when Workbook is Opened

This can only be accomplished through VBA.

1. Save your file as .xlsm
2. ALT+F11
3. Locate your Workbook name in Project Explorer Window
4. Double click on ThisWorkbook
5. Put following code in ThisWorkbook (Replace Sheet Name appropriately)

Private Sub Workbook_Open()
    Worksheets("Sheet Name").Activate
End Sub