I have built an error handler, but other workbooks that are opened are using my error handler. No matter what name I choose for the error handler, the other workbooks I have open are using the error handler as well. Is there a way to restrict this from happening? I have tried several things such as using the following in my error handling:

Application.IgnoreRemoteRequests = True

But when I use this code, all workbooks that I'm opening will not open unless it is opened directly from excel. So, no links or double-clicking the file icon from say the Desktop will open any Excel files. Then I have to put code in to reverse these effects.

Can anyone please help? Below is sort of an example of an error handler I'm using. There is more, but you should get the general idea.


On Error GoTo ErrBal

ErrBal:
Application.ScreenUpdating = False
Application.EnableEvents = False