Relative Reference Help Macros

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PhillipsHQ - 17 Aug 2006 22:56 GMT

I am trying to get relative reference to work while using my macros. The
help menu says there should be a pop-up toggle switch that allows me to
select between absolute and relative references. That button never appears.
Ideas, please?

Reply to this Message

Kevin Vaughn - 17 Aug 2006 23:13 GMT

The toggle doesn't appear when using the macros, it appears when recording
the macro (so that either relative or absolute references are used.)

Signature

Kevin Vaughn

> I am trying to get relative reference to work while using my macros. The
> help menu says there should be a pop-up toggle switch that allows me to
> select between absolute and relative references. That button never appears.
> Ideas, please?

Reply to this Message

PhillipsHQ - 18 Aug 2006 02:11 GMT

Thanks a lot. I should have been more clear with my request. I did, in
fact, mean that the pop-up did not occur when creating the macro...nice catch.

> The toggle doesn't appear when using the macros, it appears when recording
> the macro (so that either relative or absolute references are used.)
[quoted text clipped - 3 lines]
> > select between absolute and relative references. That button never appears.
> > Ideas, please?

Reply to this Message

Kevin Vaughn - 18 Aug 2006 15:29 GMT

I see that Gord correctly interpreted what you meant and provided the answer.
After I saw his reply, I figured that was more likely what you meant. Glad
he answered your question for you.

Signature

Kevin Vaughn

> Thanks a lot. I should have been more clear with my request. I did, in
> fact, mean that the pop-up did not occur when creating the macro...nice catch.
[quoted text clipped - 6 lines]
> > > select between absolute and relative references. That button never appears.
> > > Ideas, please?

Reply to this Message

Gord Dibben - 18 Aug 2006 00:46 GMT

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

>I am trying to get relative reference to work while using my macros. The
>help menu says there should be a pop-up toggle switch that allows me to
>select between absolute and relative references. That button never appears.
>Ideas, please?

Gord Dibben MS Excel MVP

Reply to this Message

PhillipsHQ - 18 Aug 2006 11:10 GMT

Home run. Thanks a million...

> Tools>Customize>Toolbars.
>
[quoted text clipped - 12 lines]
>
> Gord Dibben MS Excel MVP

Reply to this Message