Switching to relative reference for macro

C

Chris

Older versions of excel had the option to switch to
relative reference when recording macros. This option
doesn't appear available in excel 2002. Anyone know how
you switch to relative reference for recording a macro?
 
T

tomhaddock

Hi

Relative reference is located on the Record Macro toolbar after
clicking Record New Macro.

If that button is not available you will need to put the button back in
using Customise toolbars or Add More Buttons...

Tom
 
Top