Is it possible to capture chart object events for any chart object (either existing or new)? I want to be able to enable and disable custom commandbar buttons depending on whether a chart object is selected or not (the buttons run code that is specific to charts), similar to the way the Excel chart wizard button is only enabled when a chart is selected.
Capturing the events for a chart sheet is no problem, as is capturing the events for a specific named chart object, but I can't work out how to capture the events for any chart object.
Thanks
Simon
Capturing the events for a chart sheet is no problem, as is capturing the events for a specific named chart object, but I can't work out how to capture the events for any chart object.
Thanks
Simon