hides the legend when it is double-clicked; double-clicking either axis brings back the legend: : Chart Event « Excel « VBA / Excel / Access / Word






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

hides the legend when it is double-clicked; double-clicking either axis brings back the legend:

 
Private Sub MyChartClass_BeforeDoubleClick(ByVal ElementID As Long,ByVal Arg1 As Long, ByVal Arg2 As Long, Cancel As Boolean)
    Select Case ElementID
        Case xlLegend
            Me.HasLegend = False
            Cancel = True
        Case xlAxis
            Me.HasLegend = True
            Cancel = True
    End Select
End Sub








Related examples in the same category

1.Understanding Chart Events
2.Chart_Deactivate procedure also displays a message only when the chart sheet is deactivated:
3.The Chart_Select procedure listed next is executed whenever an item on the chart is selected:
4.Events with Chart Sheets
5.Events with Embedded Charts
6.Chart double click event
7.zooms in on a left mouse click and zooms out on a right mouse click.
8.Embedded Chart Mouse Events