My excel macro recorder no longer shows up when recording macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top