Microsoft Office Tutorials and References
In Depth Information
11.5 WorkBook Events
Occurs when a worksheet is right-clicked, before the default
click action.
BeforeRightClick
Calculate
Occurs after the worksheet is recalculated.
Occurs when cells on the worksheet are changed by the user or by
an external link.
Change
Deactivate
Occurs when the worksheet is deactivated.
PivotTableUpdate (Excel 10
only)
Occurs after a PivotTable report is updated on a worksheet.
SelectionChange
Occurs when the selection changes on a worksheet.
11.5 WorkBook Events
Table 11-2 shows the workbook-related events.
Table 1-2. Workbook Events 1
Event name
Description
Activate
Occurs when a workbook is activated.
AddinInstall
Occurs when the workbook is installed as an add-in.
AddinUninstall
Occurs when the workbook is uninstalled as an add-in.
BeforeClose
Occurs before the workbook closes.
BeforePrint
Occurs before the workbook (or anything in it) is printed.
BeforeSave
Occurs before the workbook is saved.
Deactivate
Occurs when the workbook is deactivated.
NewSheet
Occurs when a new sheet is created in the workbook.
Open
Occurs when the workbook is opened.
PivotTableCloseConnection (Excel 10
only)
Occurs after a PivotTable closes the connection to its data
source.
PivotTableOpenConnection(Excel 10
only)
Occurs after a PivotTable opens the connection to its data
source.
SheetActivate
Occurs when any sheet is activated.
Occurs when any worksheet is double-clicked, before the
default double-click action.
SheetBeforeDoubleClick
Occurs when any worksheet is right-clicked, before the
default right-click action.
SheetBeforeRightClick
Occurs after any worksheet is recalculated or after any
changed data is plotted on a chart.
SheetCalculate
Occurs when cells in any worksheet are changed by the
user or by an external link.
SheetChange
SheetDeactivate
Occurs when any sheet is deactivated.
Occurs when the selection changes on any worksheet
does not occur if the selection is on a chart sheet). (
SheetSelectionChange
WindowActivate
Occurs when any workbook window is activated.
WindowDeactivate
Occurs when any workbook window is deactivated.
WindowResize
Occurs when any workbook window is resized.
 
 
Search JabSto ::




Custom Search