Open Event [Excel 2003 VBA Language Reference]
Occurs when the workbook is opened.
Private Sub Workbook_Open()
Example
This example maximizes Microsoft Excel whenever the workbook is opened.
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub
Applies to | Workbook Object