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

ID: Q213672

The information in this article applies to:

Microsoft Excel 2000

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

Keywords : kberrmsg kbdta KbVBA
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb