Microsoft KB Archive/213189

= Stop Recording Toolbar is not displayed when you record a macro =

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.</li>  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. </li></ol>

<div class="moreinformation_section">

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.

<div class="references_section">