Macro-Relative Reference

[Baldeagle]

Excel's help page Create a Macro provides that you should go to the "Stop
Recording Toolbar" and click Relative Reference so that it is selected. When
I do that, no toolbar appears and all that happens is that it stops
recording. Excel 2002.

TIA for any help.

Baldeagle

 

[Bob Phillips]

Give this a try

Start recording another macro, then goto Tools>Customise and select the
Toolbars tab, then check the Stop Recording checkbox

And don't close it by hitting the "X" when recording a macro or you will
lose
it again.

 

[Baldeagle]

Thanks for the help.

Give this a try

Start recording another macro, then goto Tools>Customise and select the
Toolbars tab, then check the Stop Recording checkbox

And don't close it by hitting the "X" when recording a macro or you will
lose
it again.