trapping charts event

[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 :-(

 

[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