Relative adress in recored macro

[lwm]

I am going to teach classes in Excel Macro's and VBA. When recording a Macro
(I know about the standard tool bar) a small icon is suppose to appear
allowing you to change the recored macro between relative and absolute
addresses. I inadvertantly closed this once and have not been able to bring
it back. I have even uninstalled and reinstalled Excel.

How do I get that icon back so I can demonstrate it to the classes?

Thanks.

 

[Gord Dibben]

Tools>Customize>Toolbars.

Select the Stop Recording Toolbar.

Start Recording a macro then hit the Stop button.

DO NOT hit the "x" to stop or you will lose the Toolbar again.


Gord Dibben MS Excel MVP

 

[lwm]

Thank you Thank you. I have been going nuts trying to find this.

 

[Bill Renaud]

Gord Dibben wrote:
<<Start Recording a macro then hit the Stop button.>>

In Excel 2000, the Stop Recording toolbar goes away anyway, if you only hit
the Stop button. It does NOT remain visible after Recording has stopped.