How do i activate the Macro recorder toolbar

[KAMAKSHI_1521]

While recording a macro, I accidently closed the macro recorder toolbar
..

Now whenever I record a macro, the recording toolbar does not appear.
there fore I have to use the menu option to stop recording the macro.
Also I cannot use relative and absolute reference.

Can you please let me know how I can activate my macro recorder toolbar
to appear the moment start recording my macro.

Thanks

 

[Gord Dibben]

Tools>Customize>Toolbars. Select "Stop Recording" toolbar and "Reset".

Put a check in the checkbox.

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.

Gord Dibben Excel MVP