Restoring the Macro Recorder to Default w/ relative references sho

[Leo]

This is likely a dumb question, but I am at a loss.

I am an Access developer who uses Excel to export, format and the data for
management. Somehow, I managed to "x" out of the macro recorder while
recording. Now I can only use the View>Toolbars>Visual Basic Editor to view a
recorder toolbar. There is no Relative Reference key on this toolbar, and I
rely heavily on this since my knowledge of the Excel Object Model is rather
limted.

Is there any way, short of un-installing then re-installing Excel, to
restore the Macro Recorder to its default?

Thanks in advance ...
Leo

 

[Dave Peterson]

Start recording a new macro
Then hit View|toolbars and show "stop recording"
(xl2003 menus system)

You can discard the recorded macro when you're done.

 

[Leo]

Thanks Dave. Just what I needed. Saved me from pulling even a little more of
my already thinning hair by having to manually code hundreds of offset
commands!