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

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!




"Jon Peltier" ha scritto nel messaggio
...
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 :-(