How do i activate the Macro recorder toolbar

  • Thread starter Thread starter KAMAKSHI_1521
  • Start date Start date
K

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
 
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
 
Back
Top