Worksheet_Activate Doesn't Work On Chart Sheet

Guys, I have a chart sheet (a whole sheet that is a chart) where I need to use Worksheet_Activate, meaning to run a macro when users switches to that sheet. I tried using "Private Sub Worksheet_Activate()" as for any normal sheet, but it doesn't work: nothing happens and there's no EM. Does anyone know how can I get the same result/effect as for Worksheet_Activate on a chart sheet?
The issue is similar to the one here.


Thanks so much in advance!

A chart is not a worksheet, hence there is no worksheet_activate event for it. the event is Chart_Activate

If you select Chart from the left dropdown at the top of the main code window, the right dropdown will show you the available events and selecting one will produce the correct declaration for you.

Originally Posted by romperstomper

A chart is not a worksheet, hence there is no worksheet_activate event for it. the event is Chart_Activate

If you select Chart from the left dropdown at the top of the main code window, the right dropdown will show you the available events and selecting one will produce the correct declaration for you.

Works as charm, thanks so much!