Re: how can i turn on the relative reference icon for macro recording in excel

Hey there Eric,

Isn't MS Excel fun? :)

Usually, when you choose {Tools}>{Macro}>{record Macro}, the box with the 
{stop recording}/{relative reference} buttons pops up.  The button with 
the square is for stopping recording, and the button with the minature 
excel sheet is for relative references.

If this doesn't pop up, then BEFORE you start recording the macro, click 
{View}>{Toolbars}>{Stop Recording} from the respective panels.  The box 
should pop up then, and you can do the usual to start recording the macro.

Hope this helps!
Evelyn