Where is the Stop Recording toolbar?

[Guest]

When I record a macro, the Stop Recording toolbar does not appear. There is
no 'Macro' toolbar listed in View / Toolbars. How can I 'show' this toolbar?

When recording a macro from the keyboard, is there any way to select
'Relative Reference' without this toolbar?

Thanks!

 

[crispbd]

Go to view, toolbars, and select Visual Basic.

 

[Gord Dibben]

Tools>Customize>Toolbars. Select "Stop Recording" toolbar>Close

Stop Recording Toolbar should now be visible on sheet.

Hit "X" to close it(but not while you are recording).

It will pop up next time you use recorder. Do not close the "Stop
Recording" toolbar via "X" while recorder is running or you will lose it
again.

You can drag the "Relative Reference" button from the Visual Basic Toolbar to
any toolbar if you wish.


Gord Dibben Excel MVP