Setup for Relative reference in Macros

  • Thread starter Thread starter Tim
  • Start date Start date
T

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.
 
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
 
Back
Top