Stop Recording Toolbar is not displayed when you record a macro (213189)


The information in this article applies to:

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002
  • Microsoft Excel 2000
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel X for Mac
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q213189

SYMPTOMS

The Stop Recording toolbar does not appear while you are recording a macro.

CAUSE

This behavior occurs because you closed the Stop Recording toolbar while you were recording a macro. If you close the Stop Recording toolbar while you are recording a macro, the next time you start recording, the Stop Recording toolbar does not appear.

RESOLUTION

To resolve this problem, display the Stop Recording toolbar while you record a macro. The next time you record a macro, the problem will not occur. To display the Stop Recording toolbar while you record the macro, follow these steps:
  1. Start recording your macro.
  2. On the View menu, point to Toolbars, and then click Stop Recording.

    The Stop Recording toolbar appears.
  3. Perform any additional actions that you want to record in the macro.
  4. On the Stop Recording toolbar, click the Stop Recording button.
  5. On the Tools menu, point to Macro, and then click Macros.
  6. Click the macro name that you recorded, and then click Edit.
  7. Delete the following line from the macro:
    Application.CommandBars("Stop Recording").Visible = True
    NOTE: This line is recorded when you display the Stop Recording toolbar in step 4 and must be deleted.

MORE INFORMATION

Even when the Stop Recording toolbar is not visible, you can still stop recording the macro: on the Tools menu, point to Macro, and then click Stop Recording.

REFERENCES

For more information about recording macros, click Microsoft Excel Help on the Help menu, type record a macro in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbprb kbProgramming KB213189
©2004 Microsoft Corporation. All rights reserved.