Relative Reference Help Macros

P

PhillipsHQ

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?
 
K

Kevin Vaughn

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

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

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?
Click to expand...

Gord Dibben MS Excel MVP
 
P

PhillipsHQ

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.
 
P

PhillipsHQ

Home run. Thanks a million...

Gord Dibben said:
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



Gord Dibben MS Excel MVP
Click to expand...
 
K

Kevin Vaughn

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