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

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

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" <(E-Mail Removed)> wrote in message
news:395BEF85-1C4B-47C7-A03E-(E-Mail Removed)...
> 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
>