Don't use the events on a chart sheet's module. Add a class module, and
assign each chart to an instance of the class. More about this he
http://www.computorcompanion.com/LPMArticle.asp?ID=221
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"raidevnet" wrote in message
...
Hi to all,
I need to update a Task Pane whenever the user selects a chart.
How can this be archived?
I've tried using Chart.Activate events, which works as long as the user
does
not add new charts. In the Workbook Open event, I could then subscribe to
the
Chart.Activate event of each instance, but what if the user creates a new
chart object?
I there anything like an Application.ChartActivated/Selected event that I
missed?
Regards,
Rai