| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lost "Relative Reference" button in Excel
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!!! -- LL |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost "Relative Reference" button in Excel
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)... -- HTH... Jim Thomlinson "LL" wrote: 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!!! -- LL |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost "Relative Reference" button in Excel
Excellent. Many thanks!
-- LL "Jim Thomlinson" wrote: 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)... -- HTH... Jim Thomlinson "LL" wrote: 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!!! -- LL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't remove the Email button to the Standard toolbar in Excel | Excel Discussion (Misc queries) | |||
| Lost Excel file changes in Outlook attachment due to save process | Setting up and Configuration of Excel | |||
| Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
| Missing = sign button in excel XP and 2003 | Excel Discussion (Misc queries) | |||
| How do I setup a spin button in excel | Excel Discussion (Misc queries) | |||
Linear Mode
