MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Absolute vs. Relative References in Excel 2002

  Asked By: Molly    Date: Mar 25    Category: MS Office    Views: 1115

Any idea why Excel 2002 will only allow absolute references when
recording macros?

The icon for relative references doesn't even come up to allow the

Even if I uninstall and reinstall the program it will not allow
relative references.

Originally it was in the program.



6 Answers Found

Answer #1    Answered By: Sherri Parker     Answered On: Mar 25

They are probably still in the program. But your customised settings do
not show the relative/absolute icon. Here is a way to get it back:

Start your macro recording, so you can get the menu displayed.
Right-click on the menu, and select "Customise". Find the Macro menu,
and find the Relative/Absolute icon. Drag it to the Macro menu, and you
should be ok from there on. Let us know how it goes.

Answer #2    Answered By: Rachel Barnes     Answered On: Mar 25

I couldn't find the Relative/Absolute icon anywhere in any of the
'customize' dialogue box tabs. (xl2003)
You could try resetting the toolbar:
Tools>Customize>Toolbars. Scroll down and find the Stop Recording
Toolbar.Click on it and "Reset".
Otherwise this single line in a macro might do it:

Application.CommandBars("Stop Recording").Controls.Add Type:= _
msoControlButton, ID:=896

(you could just execute this line once in the Immediate window of the
Visual Basic Editor instead (Ctrl+G to get the Immediate Window
visible in the VBE)).

Answer #3    Answered By: Julio Morgan     Answered On: Mar 25

This does bring up the stop recording toolbar but it still will not
record using relative  references. I tired both ways of doing it and
it still does only absolute  references.

Answer #4    Answered By: Opal Alexander     Answered On: Mar 25

You're sure you're not seing the likes of:
ActiveCell.Offset(6, 3).Range("A1").Select

which in absolute  refs would be something like:

What sort of action are you recording?

Answer #5    Answered By: Coleman Smith     Answered On: Mar 25

No menu displays when I do this.

Answer #6    Answered By: Benny Torres     Answered On: Mar 25

now I know where to do it as

Didn't find what you were looking for? Find more on Absolute vs. Relative References in Excel 2002 Or get search suggestion and latest updates.