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!

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
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Simon Reid" wrote in message
...
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!