Relative adress in recored macro
 

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.

Relative adress in recored macro
 

ToolsCustomizeToolbars.

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

On Sat, 1 Dec 2007 12:47:00 -0800, lwm wrote:

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.

Relative adress in recored macro
 

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

"Gord Dibben" wrote:

ToolsCustomizeToolbars.

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

On Sat, 1 Dec 2007 12:47:00 -0800, lwm wrote:

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.

Relative adress in recored macro
 

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.

--
Regards,
Bill Renaud