How do I turn on the 'record macro' toolbar when recording a macro? I need to use relative references, and according to the VBA help
Note: You can record macros that use the Offset property instead of absolute references. On the Tools menu, point to Macro, click Record New Macro, click OK, and then click the Relative Reference button, on the record macro toolbar

Start recording a macro. go to Tools=Customize and in the first dialog
check Stop Recording. Now click the stop recording button. You can discard
this recorded macro. If you start recording again, it will automatically
appear. Don't close it with the little X in the top right or you will have
to repeat this.

--
Regards,
Tom Ogilvy

"Wayne" wrote in message
...
How do I turn on the 'record macro' toolbar when recording a macro? I need
to use relative references, and according to the VBA help:
Note: You can record macros that use the Offset property instead of
absolute references. On the Tools menu, point to Macro, click Record New
Macro, click OK, and then click the Relative Reference button, on the record
macro toolbar.

Hi Wayne

Answer from Tom Ogilvy on this problem

Start recording a macro, then right click on a blank area of a toolbar and
select the stop recording toolbar.
(or use View=Toolbars from the menu)
then click the stop button.

Now when you record, the button will appear. Don't click the x to hide it
when recording or you will have to repeat the above.



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Wayne" wrote in message ...
How do I turn on the 'record macro' toolbar when recording a macro? I need to use relative references, and according to the
VBA help:
Note: You can record macros that use the Offset property instead of absolute references. On the Tools menu, point to
Macro, click Record New Macro, click OK, and then click the Relative Reference button, on the record macro toolbar.