trapping charts event

P

PLP

I'm writing a macro in which the user has to choose 2 value on a bar-graph.
I can trap chart events as Jon Peltier say (
http://www.computorcompanion.com/LPMArticle.asp?ID=221, ), but following his
way I trap *always* chart events.
What I want is to trap chart event in a chart sheet only one time, and after
that I want to leave the charts event control back to excel.
Is it possible?

Sorry for my newbie-ness :-(
 
J

Jon Peltier

When you have the information you need, and don't need more events from the
chart, deactivate the chart events.

Set clsEventChart.EvtChart = Nothing

- Jon
 
Top