Application event for Chart selected/activated?
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 |
Application event for Chart selected/activated?
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 |
All times are GMT +1. The time now is 12:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com