When recording a macro a toolbar with two options should be displayed.
One is: Stop Recording, another toggles to: Relative References.

Tomek Polak
www.vba.blog.onet.pl