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

Article translations Article translations
Article ID: 213672 - View products that this article applies to.
This article was previously published under Q213672
Expand all | Collapse all

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.)

Properties

Article ID: 213672 - Last Review: October 11, 2006 - Revision: 3.2
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
Keywords: 
kberrmsg kbprb KB213672

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com