Disabled Absolute/Relative Macro Button

  • Thread starter Thread starter J Shrimps, Jr.
  • Start date Start date
J

J Shrimps, Jr.

When I record a new macro, the absolute/relative
reference button does not appear.
How do I re-enable it?
 
With the macro recorder running right-click anywhere in an empty region of
the toolbars and enable (click) the 'Stop Recording' toolbar.
 
???????
How will that make the absolute relative button appear?
 
You asked how to do it - this it! - Try it and you will see that next time
you record a macro the toolbar called 'Stop Recording' will appear - the
button to the right on this toolbar is the absolute/relative option.

If you dismiss this toolbar then it will not appear next time you record a
macro - so the absolute/relative button will not be visible again.

As I said try it and see for yourself!
 
Nigel,

Thank you for the fix! What a weird deal....one day it was there,
then....gone. Not too worried about the why, just am thankful that it's back.

Peter
 
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

Absolute or Relative reference - no longer a choice! 5
Macro Relative reference button greyed out. 1
relative reference pivot table macro 2
Recording Macro, toggle absolute/relative reference, button disapp 2
Missing relative reference icon 2
absolute relative reference 2
Show Record Macro Toolbar 2
create macro "merge selected cells"? 7

Back
Top