How do i make a macro "relative" to cell?

[Art Nittskoff]

I know I want to make the macro relative, but I can't find the relative button.

I record my macro, hit the tool button and tell it to stop recording. Where
do I find the relative button?

--
Thanks Very Much!

Art Nittskoff

[Earl Kiosterud]

Art,

The relative button should be on the Stop Recording toolbar, with the stop
button. You might have to use View - Toolbars - Customize to reset the Stop
Recording toolbar to its factory state.
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Art Nittskoff" <ArtNittskoff@discussions.microsoft.com> wrote in message
news:46630E72-8E1F-4C63-BC04-9E41930A7B27@microsoft.com...
>I know I want to make the macro relative, but I can't find the relative
>button.
>
> I record my macro, hit the tool button and tell it to stop recording.
> Where
> do I find the relative button?
>
> --
> Thanks Very Much!
>
> Art Nittskoff

[Debra Dalgleish]

The Relative Reference button is on the Stop Recording toolbar, that
should appear when you start recording a macro.

If it doesn't appear, there are instructions in the Excel FAQs here, for
getting it back:

http://www.contextures.com/xlfaqMac.html#Stop

Art Nittskoff wrote:
> I know I want to make the macro relative, but I can't find the relative button.
>
> I record my macro, hit the tool button and tell it to stop recording. Where
> do I find the relative button?
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[kayabob]

The relative button is at the right of the recording toolbar, right under the
x close button. It is a toggle and is either absolute or relative. To
describe the appearance, when the button is pushed in, or it may look as if
it has a lighter blue background, that is the relative recording state. If
the button looks flat, or the same color background as the rest of the tool
bar, that is the absolute recording state.

"Art Nittskoff" wrote:

> I know I want to make the macro relative, but I can't find the relative button.
>
> I record my macro, hit the tool button and tell it to stop recording. Where
> do I find the relative button?
>
> --
> Thanks Very Much!
>
> Art Nittskoff

[Leith Ross]

Hello Art,

If you want the macro to be recorded in R1C1 reference style, click on the Excel Toolbar click: Tools | Options | Genearal | Settings | R1C1 Reference Style

Sincerely,
Leith Ross