Restoring the Macro Recorder to Default w/ relative references sho
 

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 ViewToolbarsVisual 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

Restoring the Macro Recorder to Default w/ relative references sho
 

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 wrote:

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 ViewToolbarsVisual 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

Restoring the Macro Recorder to Default w/ relative references
 

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! :)

"Dave Peterson" wrote:

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 wrote:

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 ViewToolbarsVisual 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