Lost "Relative Reference" button in Excel

L

LL

I was recording a simple macros and closed a small menu that appeared
automatically. It contained the "relative reference". How can I get that
toolbox back. I tried to add the button back in by customizing my toolbar,
but it's not working. I haven't been able to record a macro since because I
can't mark a cell as the relative reference or beginning for the macro.
Please help!!!
 
J

Jim Thomlinson

Select Tools -> Customize -> Toolbars Tab -> Stop Recording (Check) -> Close
The toolbar will appear. You can just close it with the x... Next time you
record something it will appear. I you Choose the x instead of the Square to
Stop Recording then the toolbar will disappear again (so don't do that)...
 

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

WORD VBA Search and switch to advanced ... 1
Can I edit macro buttons on the quick access toolbar in excel? 0
Relative Reference Button 3
How to add cell's reference to cell's content 5
losing command button functionality 4
Change a cell reference from relative to absolute 2
Recording Macro's Mini Floating Toolbar 5
Absolute and Relative Cell References 1

Top