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