You are currently offline, waiting for your internet to reconnect

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

This article was previously published under Q213672
This article has been archived. It is offered "as is" and will no longer be updated.
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.)
XL2000 Can t execute code in break mode
Properties

Article ID: 213672 - Last Review: 12/05/2015 12:16:48 - Revision: 3.2

Microsoft Excel 2000 Standard Edition

  • kbnosurvey kbarchive kberrmsg kbprb KB213672
Feedback