-
Global Error Handling
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules