When I was done recording an Excel macro I clicked on the close toolbar X in
the upper right corner of the Stop Recording toolbar instead of the Stop
Recording button. The toolbar no longer automatically shows on the worksheet
while I am recording a macro. How can I get it back?

Start recording a new macro
Then hit View|toolbars and show "stop recording"

You can discard the recorded macro when you're done.

Carol A wrote:

When I was done recording an Excel macro I clicked on the close toolbar X in
the upper right corner of the Stop Recording toolbar instead of the Stop
Recording button. The toolbar no longer automatically shows on the worksheet
while I am recording a macro. How can I get it back?

--

Dave Peterson

or just show the design mode toolbar in your toolbar area and then it is
always there

"Carol A" wrote:

When I was done recording an Excel macro I clicked on the close toolbar X in
the upper right corner of the Stop Recording toolbar instead of the Stop
Recording button. The toolbar no longer automatically shows on the worksheet
while I am recording a macro. How can I get it back?

Thank you.
I can get it in the toolbar area, what I want is for it to show on the
worksheet after I have named the macro, etc. and actually start recording it.

"Deb-tasha" wrote:

or just show the design mode toolbar in your toolbar area and then it is
always there

"Carol A" wrote:

When I was done recording an Excel macro I clicked on the close toolbar X in
the upper right corner of the Stop Recording toolbar instead of the Stop
Recording button. The toolbar no longer automatically shows on the worksheet
while I am recording a macro. How can I get it back?