Workbook Object Events

See Also

Workbook events occur when the workbook changes or when any sheet in the workbook changes. 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.

AddinUninstall

BeforeClose

BeforePrint

BeforeSave

Deactivate

NewSheet

Open

SheetActivate

SheetBeforeDoubleClick

SheetBeforeRightClick

SheetCalculate

SheetChange

SheetDeactivate

SheetFollowHyperlink

SheetSelectionChange

WindowActivate

WindowDeactivate

WindowResize


This example maximizes Microsoft Excel when the workbook is opened

Sub Workbook_Open()
    Application.WindowState = xlMaximized
End Sub