Error Handling in Each Sub
 

I have modified the code of a series of subs that all get called from a
master sub so that each sub has its own error handling section, which has if
error goto errorarea in that sub. The code is protected with a password.
When a user runs the program, they SOMETIMES and sporatically get "project
execution has been interrupted." The choices are continue or end. Debug is
not available as the project is protected and locked. The next time they go
in to excel and run the project, it does NOT give any of these errors.
Sometimes they may get 40 during the running. Any ideas why this would
happen? Could it have anything to do with the protection?

Error Handling in Each Sub
 

sounds like something that happened to one of my coworkers. the code would
break, but you could continue all the way through to the end. every time the
code ran, it would break in a different place and never once executed the
errorhandler (almost as if someone hit ctrl+break to interrupt the macro).

she habitually logged out at the end of the day instead of rebooting the
computer. after rebooting her computer, all worked fine.

other than that, I'm not sure.


"Mike H." wrote:

I have modified the code of a series of subs that all get called from a
master sub so that each sub has its own error handling section, which has if
error goto errorarea in that sub. The code is protected with a password.
When a user runs the program, they SOMETIMES and sporatically get "project
execution has been interrupted." The choices are continue or end. Debug is
not available as the project is protected and locked. The next time they go
in to excel and run the project, it does NOT give any of these errors.
Sometimes they may get 40 during the running. Any ideas why this would
happen? Could it have anything to do with the protection?