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

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

SYMPTOMS

In the versions of Microsoft Excel listed above, if you attempt to run a macro, one or more of the following problems may occur:

  • If you click the Tools menu and point to Macro, one of the following problems may occur if you click the Macros menu item:

    1. Nothing happens; the menu does not disappear, and the Macro dialog box is not displayed. You cannot click the Macros menu item.
    2. The menu disappears, but the Macro dialog box is not displayed.
  • If you attempt to run a macro, either from the Macro dialog box, from within the Visual Basic Editor, or by pressing its shortcut key, you receive the following error message:
    Microsoft Visual Basic
    Can't execute code in break mode

CAUSE

These problems will occur if, when you attempt to run a macro, another macro is currently in break mode. This may occur if you have added a breakpoint to a macro by selecting a line of code and pressing F9, or if a macro contains the following line of code:
   Stop
				

RESOLUTION

To exit break mode, activate the Visual Basic Editor by clicking the Tools menu, pointing to Macro, and clicking Visual Basic Editor. Then, either:

  • On the Standard toolbar, click the Reset button. This halts all macro execution. -or-

  • Either click the Continue tool on the Standard toolbar or press F5. The halted macro will continue its execution.

STATUS

This behavior is by design of the versions of Microsoft Excel listed at the beginning of this article; it is not possible to run a Visual Basic macro when another macro is in break mode.

Properties

Article ID: 177828 - Last Review: October 11, 2006 - Revision: 1.3
APPLIES TO
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 98 for Macintosh
Keywords: 
kberrmsg kbprb KB177828
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

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