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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record Macro Toolbar 1
Quick Access Tool Bar 1
Excel 2007: Help creating a macro that will run Solver? 3
No macro recording dialog box 2
How do I get the Stop Recording toolbar to show on the worksheet? 3
How do I get the Stop Recording toolbar to show on the worksheet? 1
Word VBA to update cross-referencing 0
unable to delete Macro names 1

Back
Top