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
doubleclick action.
Occurs when an embedded chart is right-clicked, before the default right-click
action.
BeforeRightClick
Calculate
Occurs after the chart plots new or changed data.
Deactivate
Occurs when the chart is deactivated.
DragOver
Occurs when a range of cells is dragged over a chart.
DragPlot
Occurs when a range of cells is dragged and dropped on a chart.
MouseDown
Occurs when a mouse button is pressed while the pointer is over a chart.
MouseMove
Occurs when the position of the mouse pointer changes over a chart.
MouseUp
Occurs when a mouse button is released while the pointer is over a chart.
Resize
Occurs when the chart is resized.
Select
Occurs when a chart element is selected.
SeriesChange
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
Event name
Description
NewWorkbook
Occurs when a new workbook is created.
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
Occurs after the sheet containing the PivotTable
report has been updated.
SheetPivotTableUpdate (Excel 10 only)
 
 
 
 
Search JabSto ::




Custom Search