Workbook activated in Protected View mode.
Workbook closed in Protected View mode.
Editing mode enabled of a protected workbook.
Workbook deactivated in Protected View mode.
Workbook opened in Protected View mode.
Window resized of the protected workbook.
Any sheet is activated.
Any worksheet is deleted.
Any worksheet is double-clicked.
Any worksheet is right-clicked.
Any worksheet is recalculated.
Cell in any worksheet is changed.
Any sheet is deactivated.
User clicked any hyperlink in any sheet.
User selected the Quick Analysis tool in any sheet.
Selection changed on any worksheet.
Table object changed or updated on any worksheet.
Cells edited inside a pivot table in any sheet.
A pivot table is updated from its OLAP data source in any sheet.
A OLAP pivot table updates its data source in any sheet.
A OLAP pivot table discards changes from its data source in any sheet.
A pivot table updated in any sheet.
A pivot table report closes its connection to its data source.
A pivot table report opens a connection to its data source.
A user drills through a record set or calls upon the row set action on an OLAP pivot table.
User exported or saved XML data.
User imported the XML data.
Before exporting the XML data.
Before importing the XML data.
Workbook window is activated.
Workbook window is deactivated.
Workbook window is resized.
Workbook is activated
Any open workbook is deactivated.
All calculation activities completed.
An addin installed.
An addin uninstalled.
Workbook remotely edited.
Before workbook remotely edited.
A user synchronizes the local copy of a sheet in a workbook that is part of a document workspace with the copy on the server.
Workbook is saved.
Before any open workbook closes.
Before any open workbook is saved.
A workbook is opened
Before any open workbook is printed.
Data Model changed in a workbook.
A new workbook is created.
A new chart is created in any open workbook
A new sheet is created in any open workbook
The Workbook and Worksheet events occur for a particular workbook or for a particular worksheet. But the Application-level events occurs for the Excel application which affect all available workbooks and worksheets. You’ll not find any code module in the VBA Project Explorer tree for writing the code for Application events. You can enable Application-Events by writing some VBA code in
ThisWorkbook code module. See how to listen Application events. Following is the list of Application events with brief description: