Workbook_Open runs when the file opens (if macros are enabled). Use it for setup: landing on a home sheet, refreshing data, or showing a reminder.

Code

Private Sub Workbook_Open()
  Worksheets("Home").Activate
End Sub

• Land on a sheet

  Private Sub Workbook_Open() Worksheets("Home").Activate End Sub → Always opens on the Home sheet

  A friendly start.

• Refresh on open

  Private Sub Workbook_Open() ThisWorkbook.RefreshAll End Sub → Refreshes queries and pivots on open

  Fresh data every time.

• Reminder

  Private Sub Workbook_Open() If Date > DateSerial(2026, 1, 1) Then MsgBox "Update the rates" End Sub → A dated reminder

  Maintenance nudges.

• Hold Shift while opening to skip it.
• Auto_Open in a standard module is the older equivalent.
• Keep it fast; users are waiting.

• Does not run when macros are blocked, so never rely on it for security.
• Errors in it make the file appear broken on open.