ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to get the macro record button back (https://www.excelbanter.com/excel-programming/305097-how-get-macro-record-button-back.html)

steve

How to get the macro record button back
 
The button that has the stop macro record and relative has
disappeared from my screen when recording a macro. I've
looked in the references and can not find out how to get
the button back. I'm sure it easy ..... help.

JulieD

How to get the macro record button back
 
Hi Steve

when you're recording a macro next choose view / toolbars / stop recording
- and then don't close it again :)

this should set the behaviour of the button back to normal

Cheers
JulieD

"steve" wrote in message
...
The button that has the stop macro record and relative has
disappeared from my screen when recording a macro. I've
looked in the references and can not find out how to get
the button back. I'm sure it easy ..... help.




Tom Ogilvy

How to get the macro record button back
 
Start recording a macro, then do view = toolbars and click on the Stop
Recording entry.

this will make the stop recording toolbar visible. Now you can click the
stop recording button and then discard the recorded macro.

Now when you start recording, the stop recording toolbar will appear. Avoid
closing the stop recording toolbar by clicking the upper right corner.

--
Regards,
Tom Ogilvy


"steve" wrote in message
...
The button that has the stop macro record and relative has
disappeared from my screen when recording a macro. I've
looked in the references and can not find out how to get
the button back. I'm sure it easy ..... help.





All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com