Microsoft KB Archive/213672

= XL2000: "Can't Execute Code in Break Mode" When Running Macro =

Article ID: 213672

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213672





SYMPTOMS
When you attempt to run a macro from the Macro dialog box, from within the Visual Basic Editor, or by pressing the macro's shortcut key, you receive the following error message:

Can't execute code in break mode.

In addition, when you attempt to click the Macros command on the Macro submenu of the Tools menu, nothing happens. You cannot click the Macros command and display the Macro dialog box.

You may also notice that the Record New Macro command on the Macros submenu of the Tools menu is not available (appears dimmed).



CAUSE
This behavior occurs when you attempt to run a macro and another macro is in break mode. For example, this can occur if you have added a breakpoint to a macro by selecting a line of code and pressing F9, or by adding the following line of code to the macro: Stop



RESOLUTION
Exit break mode. To do this, switch to the Visual Basic editor and use any of the following methods:
 * Click the Reset button on the Standard toolbar. (This option halts the macro.)
 * Click the Continue button on the Standard toolbar. (This option finishes running the macro.)
 * Press F5. (This option finishes running the macro.)

Additional query words: XL2000 Can t execute code in break mode

Keywords: kberrmsg kbprb KB213672

-

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

© Microsoft Corporation. All rights reserved.