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
    Application.EnableCancelKey = xlErrorHandler
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?