Microsoft Office Tutorials and References
In Depth Information
11.6 Chart Events
Incidentally, a user can suppress the Open event for a workbook by holding down the Shift key
when opening the workbook.
11.6 Chart Events
Table 11-3 shows the chart-related events.
Table 11-3. Chart Events
Event name Description
Activate Occurs when a chart sheet or embedded chart is activated.
BeforeDoubleClick Occurs when an embedded chart is double-clicked, before the default
Occurs when an embedded chart is right-clicked, before the default right-click
Occurs after the chart plots new or changed data.
Occurs when the chart is deactivated.
Occurs when a range of cells is dragged over a chart.
Occurs when a range of cells is dragged and dropped on a chart.
Occurs when a mouse button is pressed while the pointer is over a chart.
Occurs when the position of the mouse pointer changes over a chart.
Occurs when a mouse button is released while the pointer is over a chart.
Occurs when the chart is resized.
Occurs when a chart element is selected.
Occurs when the user changes the value of a chart data point.
11.7 Application Events
Table 11-4 shows the Application-level events. These events apply to all objects in the currently
running instance of Excel.
Table 11-4. Application Events
Occurs when a new workbook is created.
Occurs when any sheet is activated.
Occurs when any worksheet is double-clicked,
before the default double-click action.
Occurs when any worksheet is right-clicked, before
the default right-click action.
Occurs after any worksheet is recalculated or after
any changed data is plotted on a chart.
Occurs when cells in any worksheet are changed by
the user or by an external link.
Occurs after the sheet containing the PivotTable
report has been updated.
SheetPivotTableUpdate (Excel 10 only)