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" <(E-Mail Removed)> wrote in message
news:F6A9749F-5554-42D1-8B49-(E-Mail Removed)...
> 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!