Hi,

I am trying to implement some Global Error Handling to a Revenue Forecast model workbook I have developed.

In the Open_Workbook routine I set

On Error Goto ErrorHandler:

Then within that same routine I create a basic ErrorHandler to display a message box and then close the workbook.

The problem I have is that the ErrorHandler doesn't seem to fire for any of the errors that get reported by Excel....I still get the default Error Message box giving the user the option to Debug, End or Continue..

I had thought from my reading that once you set an On Error statement that it stays inforce until you set an On Error Goto 0....but it doesn't seem to working like that for me...

Any help appreciated..

Scott