Article ID: 213189
Article Last Modified on 1/24/2007
APPLIES TO
- Microsoft Office Excel 2003
- Microsoft Excel 2002 Standard Edition
- Microsoft Excel 2000 Standard Edition
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 2004 for Mac
- Microsoft Excel X for Mac
- Microsoft Excel 2001 for Mac
- Microsoft Excel 98 for Macintosh
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:
- Start recording your macro.
- On the View menu, point to Toolbars, and then click Stop Recording.
The Stop Recording toolbar appears. - Perform any additional actions that you want to record in the macro.
- On the Stop Recording toolbar, click the Stop Recording button.
- On the Tools menu, point to Macro, and then click Macros.
- Click the macro name that you recorded, and then click Edit.
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.
Additional query words: stop button record XL2000 relative reference XL 97 XL2000, XL2002, XL2003, MAC XL 98, MAC X, MAC 2004
Keywords: kbprb kbprogramming KB213189