trapping charts event

  • Thread starter Thread starter PLP
  • Start date Start date
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 :-(
 
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
 
Mr. Peltier, first of all my best compliments for your site!
Well, I follow the instruction but i was wrong in something, so I had
problem.
Now I solved them.... :-)
I did not understood the right place for the code, but I had an insight and
now it works fine.
Thankx again!
 
Back
Top