ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My excel macro recorder no longer shows up when recording macro (https://www.excelbanter.com/excel-discussion-misc-queries/129317-my-excel-macro-recorder-no-longer-shows-up-when-recording-macro.html)

jack

My excel macro recorder no longer shows up when recording macro
 
My macro recorder tool bar no longer shows when I record a macro, I am no
longer able to switch to and from relative references

Ron de Bruin

My excel macro recorder no longer shows up when recording macro
 
Hi Jack

See this page with the solution
http://www.contextures.com/xlfaqMac.html#Stop

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"jack" wrote in message ...
My macro recorder tool bar no longer shows when I record a macro, I am no
longer able to switch to and from relative references


Gord Dibben

My excel macro recorder no longer shows up when recording macro
 
Jack

ToolsCustomizeToolbars.

Select the Stop Recording Toolbar.

Start Recording a macro then hit the Stop button.

DO NOT hit the "x" to stop or you will lose the Toolbar again.


Gord Dibben MS Excel MVP

On Mon, 5 Feb 2007 12:03:00 -0800, jack wrote:

My macro recorder tool bar no longer shows when I record a macro, I am no
longer able to switch to and from relative references



Roger Govier

My excel macro recorder no longer shows up when recording macro
 
Hi Jack

When you start to record a macro, right click on a blank area of your
toolbar and from the Toolbars dropdown you will see Stop Recording.
Select it and your floating toolbar with the relative reference will
re-appear.

Remember to finish the macro with the Stop button, not the "x" otherwise
it will close on you again.

--
Regards

Roger Govier


"jack" wrote in message
...
My macro recorder tool bar no longer shows when I record a macro, I am
no
longer able to switch to and from relative references





All times are GMT +1. The time now is 05:26 PM.

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