Workbook Events

Workbook Activate Event

This event will run code whenever this specific workbook is activated.

See: Workbook Activate Event

Workbook AddinInstall Event

This event will run when the specific workbook is installed as Add-In in Excel.

See: Workbook AddinInstall Event

Workbook AddinUninstall Event

This event will run when this workbook is uninstalled from Excel's Add-Ins. 

See: Workbook AddinUninstall Event

Workbook AfterSave Event

This event will run after the specific workbook is saved.

See: Workbook AfterSave Event

Workbook AfterXmlExport Event

This event will run after exporting XML map within an excel workbook.

See: Workbook AfterXmlExport Event

Workbook AfterXmlImport Event

This event will run after importing a new or refreshing an already created XML map within this specific excel workbook.

See: Workbook AfterXmlImport Event

Workbook BeforeClose Event

This event will run before a workbook closes.

See: Workbook BeforeClose Event

Workbook BeforePrint Event

This event will run before a workbook prints.

See: Workbook BeforePrint Event

Workbook BeforeSave Event

This event will run before a workbook saves.

See: Workbook BeforeSave Event

Workbook BeforeXmlExport Event

This event will run before Excel saves or exports XML data from this specific workbook.

See: Workbook BeforeXmlExport Event

Workbook BeforeXmlImport Event

This event will run before Excel imports XML data into or refreshes XML data within this specific workbook.

See: Workbook BeforeXmlImport Event

Workbook Deactivate Event

This event will run every time a user selects a different workbook.

See: Workbook Deactivate Event

Workbook NewChart Event

This event will run every time a new chart is created in the specific workbook.

See: Workbook NewChart Event

Workbook NewSheet Event

This event will run every time a new worksheet is created within the specific workbook.

See: Workbook NewSheet Event

Workbook Open Event

This event will run every time this specific workbook is opened.

See: Workbook Open Event

Workbook PivotTableCloseConnection Event

This event will run every time a pivot table connection is closed within the specific workbook.

See: Workbook PivotTableCloseConnection Event

Workbook PivotTableOpenConnection Event

This event will run every time a pivot table connection is closed within the specific workbook.

See: Workbook PivotTableOpenConnection Event

Workbook SheetActivate Event

This event will run every time any worksheet within the specific workbook is activated. This event will occur after the Worksheet SheetActivate Event for the worksheet that is activated.

See: Workbook SheetActivate Event

Workbook SheetBeforeDoubleClick Event

This event will run after a user double clicks within any of the worksheets in this specific workbook. This event will occur after the Worksheet SheetBeforeDoubleClick Event for the worksheet that is double clicked.

See: Workbook SheetBeforeDoubleClick Event

Workbook SheetBeforeRightClick Event

This event will run after a user right clicks within any of the worksheets in this specific workbook. This event will occur after the Worksheet SheetBeforeRightClick Event for the worksheet that is right clicked.

See: Workbook SheetBeforeRightClick Event

Workbook SheetCalculate Event

This event will run after any of the worksheets within this specific workbook have to be calculated.  This event occurs after the Worksheet SheetCalculate Event for that specific worksheet that was calculated.

See: Workbook SheetCalculate Event

Workbook SheetChange Event

This event will run after a user edits a cell or cells within any worksheet within this workbook.  This event will occur after the Worksheet SheetChange Event for the specific worksheet that is being changed.

See: Workbook SheetChange Event

Workbook SheetDeactivate Event

This event will run after any of the worksheets within this specific workbook become deactivated. This event will occur after the Worksheet SheetDeactivate Event for the specific worksheet that is being deactivated.

See: Workbook SheetDeactivate Event

Workbook SheetFollowHyperlink Event

This event will run code when a user selects a link to follow within any worksheet within this specific workbook. This event will occur after the Worksheet SheetFollowHyperlink Event for the specific worksheet that contains the hyperlink being followed.

See: Workbook SheetFollowHyperlink Event

Workbook SheetPivotTableUpdate Event

See: Workbook SheetPivotTableUpdate Event

Workbook SheetSelectionChange Event

This event will run code when a user selects a new range within any worksheet in this specific workbook.  This event will occur after the Worksheet SheetSelectionChange Event for the worksheet that contains the newly selected range.

See: Workbook SheetSelectionChange Event

Workbook WindowActivate Event

This event will run any time this specific workbook window is activated.

See: Workbook WindowActivate Event

Workbook WindowDeactivate Event

This event will run any time this specific workbook window is deactivated.

See: Workbook WindowDeactivate Event

Workbook WindowResize Event

This event will run any time this specific workbook window is resized.

See: Workbook WindowResize Event