Chart Code

[Bill]

Hello,
I have a chart that I want to check for data labels when the chart is
deactivated. So, I have inserted the following code in the chart page:

Private Sub Chart_Deactivate()
MsgBox ActiveSheet.Name
End Sub

The active sheet is the sheet I selected. Not the chart sheet. How do I
do this?

Thanks.

Bill

 

[Andy Pope]

Hi Bill,

Try,

Private Sub Chart_Deactivate()
MsgBox Me.Name
End Sub

Cheers
Andy

 

[Bill]

Thanks Andy.

Hi Bill,

Try,

Private Sub Chart_Deactivate()
MsgBox Me.Name
End Sub

Cheers
Andy