Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Stop Recording Toolbar is not displayed when you record a macro


View products that this article applies to.

Symptoms

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

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Keywords: KB213189, kbprogramming, kbprb

↑ Back to the top

Article Info
Article ID : 213189
Revision : 9
Created on : 1/24/2007
Published on : 1/24/2007
Exists online : False
Views : 372