Toggle switch between absolute and relative values creating a macr

Hello,
Why is it that when creating a macro sometimes I see the toggle switch for
absolute/relative values and sometimes I don't?

Actually, I no longer see the toggle switch when recording a new macro. What
do I have to do to make it reappear? Thank you.

"Al" wrote:

> Hello,
> Why is it that when creating a macro sometimes I see the toggle switch for
> absolute/relative values and sometimes I don't?

Al

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

On Thu, 29 Sep 2005 10:41:04 -0700, "Al" <[email protected]> wrote:

>Actually, I no longer see the toggle switch when recording a new macro. What
>do I have to do to make it reappear? Thank you.
>
>"Al" wrote:
>
>> Hello,
>> Why is it that when creating a macro sometimes I see the toggle switch for
>> absolute/relative values and sometimes I don't?

When the Stop Recording toolbar (and most toolbars) appears automatically
and you close it by clicking the "x" it takes the hint and no longer appears
automatically. So you shouldn't close it that way. To make it reappear,
start recording a macro and then View, Toolbars, Customize and select Stop
Recording from the Toolbars list.

--
Jim
"Al" <[email protected]> wrote in message
news:[email protected]...
| Actually, I no longer see the toggle switch when recording a new macro.
What
| do I have to do to make it reappear? Thank you.
|
| "Al" wrote:
|
| > Hello,
| > Why is it that when creating a macro sometimes I see the toggle switch
for
| > absolute/relative values and sometimes I don't?

Thank you very much Jim.

"Al" wrote:

> Hello,
> Why is it that when creating a macro sometimes I see the toggle switch for
> absolute/relative values and sometimes I don't?