View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michel[_3_] Michel[_3_] is offline
external usenet poster
 
Posts: 23
Default How auto EnableEvents again on code-break and errors?

When one hits "End" on a error in the code after a EnableEvents=false,
the complete programming has been finised!

So how can a automaticly re-enable the events?

I tryed using a sub with EnableEvents=True that get's executed with a
OnTime-event after the code has been finished, but this gives "Can't
execute code in break mode" while I'm debugging and programming.

Also if I go in break-mode while debugging, the last line that
re-enables the events isn't getting executed. This way I need to
enable the events manually before I can start debugging it again.