Chart_Deactivate procedure also displays a message only when the chart sheet is deactivated: : Chart Event « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Chart Event

Chart_Deactivate procedure also displays a message only when the chart sheet is deactivated:

 
Private Sub Chart_Deactivate()
    msg = "Thanks for viewing the chart."
    MsgBox msg, , ActiveWorkbook.Name
End Sub








Related examples in the same category

1.Understanding Chart Events
2.The Chart_Select procedure listed next is executed whenever an item on the chart is selected:
3.Events with Chart Sheets
4.Events with Embedded Charts
5.Chart double click event
6.hides the legend when it is double-clicked; double-clicking either axis brings back the legend:
7.zooms in on a left mouse click and zooms out on a right mouse click.
8.Embedded Chart Mouse Events