Setup for Relative reference in Macros

[Tim]

I have Excel/Office 2000 installed. I need to get relative
references turned on/set up, I can record a macro but when
I stop recording the relative reference icon is not on my
macro button. I have Office premium CD.

 

[Gord Dibben]

Tim

Try Tools>Customize>Toolbars. Select but don't checkmark the Stop Recording
toolbar. Hit Reset. Relative Reference Button should be available on the
toolbar when you checkmark it next.

Gord Dibben Excel MVP