Error handler ignored when Break on All Errors is selected (213269)


The information in this article applies to:

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002
  • Microsoft Excel 2000
  • Microsoft Excel 97 for Windows
This article was previously published under Q213269

SYMPTOMS

When you use error handlers in Microsoft Visual Basic for Applications code, the error handlers are ignored if you have the Break on All Errors option selected in the Options dialog box. Instead of running the error handler as expected, the code stops and the corresponding error message appears, just as if there were no error handler.

RESOLUTION

To turn off the Break on All Errors option, follow these steps:
  1. Start Excel, and then press ALT+F11 to open the Visual Basic Editor.
  2. In the Visual Basic Editor, click Options on the Tools menu, and then click the General tab.
  3. Click the Break on Unhandled Errors option, and then click OK.
Modification Type:MinorLast Reviewed:10/28/2004
Keywords:kbbug kbpending kbProgramming KB213269
©2004 Microsoft Corporation. All rights reserved.