My excel macro recorder no longer shows up when recording macro

[jack]

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]

Hi Jack

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

 

[Gord Dibben]

Jack

Tools>Customize>Toolbars.

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

 

[Roger Govier]

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.