Page 283 - Excel Data Analysis

15 537547 AppC.qxd 3/4/03 11:56 AM Page 269

VBA AND EXCEL EVENTS QUICK REFERENCE C

EXCEL EVENTS QUICK REFERENCE (CONTINUED)

Workbook Events (Continued)
EVENT DESCRIPTION
BeforeClose A workbook closes.
BeforePrint Excel prints a portion of a workbook.
BeforeSave Excel saves a workbook.
Deactivate Excel deactivates a workbook.
NewSheet Excel adds a new sheet to a workbook.
Open Excel opens a workbook.
PivotTableCloseConnection Occurs after a PivotTable report closes the data source connection.
PivotTableOpenConnection Occurs after a PivotTable report opens the data source connection.
SheetActivate Excel activates a sheet in the workbook.
SheetBeforeDoubleClick Occurs before a user double-clicks a sheet.
SheetBeforeRightClick Occurs before a user clicks a sheet with the right mouse button.
SheetCalculate Excel calculates a sheet.
SheetDeactivate Excel deactivates a sheet.
SheetFollowHyperlink A user clicks a hyperlink on a sheet.
SheetPivotTableUpdate Excel updates a sheet of a PivotTable report.
SheetSelectionChange The selection changes on a workbook.
WindowActivate Excel activates a workbook window.
WindowDeactivate Excel deactivates a workbook window.
WindowResize Excel resizes a workbook window.
Worksheet Events
EVENT DESCRIPTION
Activate Excel activates the worksheet.
BeforeDoubleClick Occurs before the user double-clicks the worksheet with the mouse.
BeforeRightClick Occurs before the user clicks the worksheet with the right mouse button.
Calculate Excel calculates the worksheet.
Change Occurs when a user or external link modifies cells on the worksheet.
Deactivate Excel deactivates the worksheet.
FollowHyperlink User selects a hyperlink on the worksheet.
PivotTableUpdate Occurs after a PivotTable report is updated on the worksheet.
SelectionChange Selection changes on the worksheet.

269