Workbook.Open Event (Excel)
Occurs when the workbook is opened.
Syntax
expression .Open
expression An expression that returns a Workbook object.
Example
This example maximizes Microsoft Excel whenever the workbook is opened.
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub