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!