How to run a subroutine if the main routine crashes

[Phixer]

What I want to write is a piece of code that, no matter WHERE in the process the program is running, if it hits an error I haven't coded for, it runs this one subroutine.

I was thinking I use

Please Login or Register  to view this content.

but that seems to be limited to requiring one in EACH subroutine, unless I am reading this incorrectly. What I am hoping for is one piece of code that rides overwatch over the whole process and, before it passes control to the user after a code break, it runs one subroutine first.

Any ideas? Will the Application.EnableCancelKey work for that?

[romperstomper]

Enablecancelkey only works for the user interrupting the process, not unhandled errors. The only way you can have a global error handler like that really is to pass errors back up the stack to an error handler in the main calling routine - if you have error handling in the called routines, they need to pass the error back by raising it again.

[Phixer]

Is there an event I can, perhaps, tie it to? One that happens once control is returned to the user?

[romperstomper]

Nope - you're in break mode then and no code will run.