Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UDF Error Handling is ignored. Not for everyone? | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error handling with a handling routine | Excel Programming | |||
Error handling | Excel Programming | |||
Error handling | Excel Programming |