Events

[Patros]

Hello,
Is there any possibility to temporarily disable the event procedures in vba
like in Excel (where, if I'm right it is something like
"Application.EnableEvents=True/False")?
Thank you

 

[Albert D. Kallal]

Not that I know of.

However, since you can write code to do almost any data operation, then
generally that feature is not missed.

 

[James Goodman]

I cant see this being possible.

If you disable events, then how do you re-enable them, because the event
triggered to re-enable them would be disabled?



--
Cheers,


James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures

 

[Dave]

You could declare a global variable

Global varEnabled as Boolean

then at the begining of each event check to see if varEnabled = True

If varEnabled = True then
....
code
....
End if

then all you need to do is change the variable to turn events on or off
obviously the event that changes the vaeEnable would not have the

If varEnabled = True then
....
code
....
End if

code at the beginning of it.