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