Workbook Object Events [Excel 2003 VBA Language Reference]
Workbook events occur when the workbook changes, when any sheet in the workbook changes, when add-ins change, or when PivotTables change. Events on workbooks are enabled by default. To view the event procedures for a workbook, right-click the title bar of a restored or minimized workbook window and click View Code on the shortcut menu. Select the event name from the Procedure drop-down list box.
Activate | SheetBeforeDoubleClick |
This example maximizes Microsoft Excel when the workbook is opened
Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub
See Also | Application Object Events | Chart Object Events | Control and Dialog Box Events | Using Events with Embedded Charts | Using Events with Microsoft Excel Objects | Using Events with the Application Object | Worksheet Object Events