Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Application EnableEvents
8 views
Skip to first unread message
B Lynn B
Oct 20, 2009, 5:11:01 PM10/20/09
to
If I set EnableEvents to False while my code is running, and then
accidentally exit the code without setting back to True - does this property
get reset to True when Excel is closed? My testing seems to verify that it
does, but I'm at a point where I could use confirmation. Thanks!
accidentally exit the code without setting back to True - does this property
get reset to True when Excel is closed? My testing seems to verify that it
does, but I'm at a point where I could use confirmation. Thanks!
Gord Dibben
Oct 20, 2009, 5:37:16 PM10/20/09
to
It resets to TRUE when Excel is closed.
Gord Dibben MS Excel MVP
JockW
Oct 20, 2009, 5:55:10 PM10/20/09
to
Hi
Your code will be reset when the workbook is opened again.
Your code will be reset when the workbook is opened again.
You could add:
Sub reset()
Application.EnableEvents = True
End Sub
to tour worksheet code.
If your code is stopped for whatever reason, press <Alt> + <F8> and select
this sub to re-enable your code.
Saves shutting down and starting again.
hth.
Jock
0 new messages