Show Record Macro Toolbar

[Guest]

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

 

[Tom Ogilvy]

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

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.

 

[Ron de Bruin]

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)

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.