Workbook.Open Event (Excel)
Occurs when the workbook is opened.
Syntax
식 .Open
식 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