View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default 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?