When an unrecoverable error occurs in a level 3 sub() and the level 1 sub() set EnableEvents = False, how do the experts let VBA know that it needs to set EnableEvents = True? Or re-protect a sheet, or reset FreezePanes, etc when necessary?
When an unrecoverable error occurs in a level 3 sub() and the level 1 sub() set EnableEvents = False, how do the experts let VBA know that it needs to set EnableEvents = True? Or re-protect a sheet, or reset FreezePanes, etc when necessary?
you can raise a custom error that is not handled by any intermediate error handlers. or use functions that return error or success values
Josie
if at first you don't succeed try doing it the way your wife told you to
I had a thread that I suspected had crashed when events were disabled - I sent code to enable events but I don't think they did - two weeks of coding down the drain![]()
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks