Hiking

ToolsCustomizeToolbars. Scroll down and find the Stop Recording Toolbar.

Click on it and "Reset" to get the Relative button back.

Make sure it is checkmarked then OK your way out.

Record a simple throwaway macro to make sure all is working correctly then hit
the Stop Recording button.

DO NOT close out using the X while recording or you will lose it again.


Gord Dibben Excel MVP

On Wed, 02 Feb 2005 13:26:39 -0500, Hiking
wrote:

Ron de Bruin and Don Guillett have the simple solution I was looking for.

I spent countless hours, search after search, scouring web site after
web site for just this solution, but never in all the sites and pages
did I run across just this, just what I was looking for. Unbelievable.
I knew there had to be something this simple, I knew this I was trying
to do had to be a basic, fundamental, essential element/function in/of
Excel, but damnit, nowhere was I finding it. Thanks all.

As for the macro problem, I am still interested in getting that small
toolbar back, if anyone knows how. I have gone to the Customize window,
and put on my toolbars on top the Start and Stop macro buttons, but just
cannot find that "Relative" button that used to be on that toolbar.
This toolbar would pop up on top of the spreadsheet when I went Tools
Macro Record New Macro... Now that toolbar doesn't appear anymore,
and while I have found macro-related Start Stop buttons in the Customize
window, I can't seem to find anywhere that "Relative" button that used
to appear with that pop-up toolbar I've just mentioned above.

???