Microsoft KB Archive/213269

= Error handler ignored when Break on All Errors is selected =

Article ID: 213269

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



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.

Additional query words: error eror XL2000

Keywords: kbbug kbpending kbprogramming KB213269

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.