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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"PLP" wrote in message
...
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 :-(