Chart selection changed event

[Simon Reid]

If I have a worksheet which contains two charts, is there an event that I can
catch which will tell me when the user changes their selection from one to
the other? The reason is I have some Ribbon controls that change depending
on the chart type, and I want to invalidate the ribbon if the chart selection
changes

Many thanks in advance!

 

[Andy Pope]

Hi,

You can use a class to capture chartobject events. There is an Activate or
Deactivate event you could hook into.
http://www.computorcompanion.com/LPMArticle.asp?ID=221


Cheers
Andy