The Relative Reference button is on the Stop Recording toolbar, that
should appear when you start recording a macro.

If it doesn't appear, there are instructions in the Excel FAQs here, for
getting it back:

http://www.contextures.com/xlfaqMac.html#Stop

Art Nittskoff wrote:
I know I want to make the macro relative, but I can't find the relative button.

I record my macro, hit the tool button and tell it to stop recording. Where
do I find the relative button?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html