Thread: Absolute or Relative reference - no longer a choice!

When I used to click-on or select the record macro button, a small icon used to pop-up that allowed me to select whether I wanted absolute or relative reference. For some reason, the icon does not display anymore, and I don't know how to record a macro in relative; it automatically records in absolute.

I needed a macro to work using the two cells next to wherever the cursor was placed, and I ended up having to edit the recorded macro by replacing the absolute cell references with "with selection" and "end with". This worked, even if it is not the proper way to get relative reference.

How can I (again) choose whether a macro is recorded using relative or absolute reference?

Thanks!

Alex

Click on Tools -> Customize -> Toolbars and Check Stop Recording. The tool
bar you are refering to should pop up. Now record a macro, and click stop
(not close) on the stop recording menu. The menu should disappear. It will
now come back in the future...
--
HTH...

Jim Thomlinson


"Ingeniero1" wrote:

>
> When I used to click-on or select the record macro button, a small icon
> used to pop-up that allowed me to select whether I wanted absolute or
> relative reference. For some reason, the icon does not display anymore,
> and I don't know how to record a macro in relative; it automatically
> records in absolute.
>
> I needed a macro to work using the two cells next to wherever the
> cursor was placed, and I ended up having to edit the recorded macro by
> replacing the absolute cell references with "-with selection-" and
> "-end with-". This worked, even if it is not the proper way to get
> relative reference.
>
> How can I (again) choose whether a macro is recorded using relative or
> absolute reference?
>
> Thanks!
>
> Alex
>
>
> --
> Ingeniero1
> ------------------------------------------------------------------------
> Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
> View this thread: http://www.excelforum.com/showthread...hreadid=510161
>
>

Open up the toolbar...
Tools>Customize>Toolbars
Select 'Stop Recording'
Close the 'Stop Recording' button by 'x'ing out of it. It should re-appear
from now on.

or

run this macro called TryMe...

'/======================================/
Public Sub TryMe()
Application.CommandBars("Stop Recording").Visible = True
End Sub
'/======================================/

and then close the 'Stop Recording' button by 'x'ing out of it. It should
re-appear from now on.

HTH,

--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Ingeniero1" wrote:

>
> When I used to click-on or select the record macro button, a small icon
> used to pop-up that allowed me to select whether I wanted absolute or
> relative reference. For some reason, the icon does not display anymore,
> and I don't know how to record a macro in relative; it automatically
> records in absolute.
>
> I needed a macro to work using the two cells next to wherever the
> cursor was placed, and I ended up having to edit the recorded macro by
> replacing the absolute cell references with "-with selection-" and
> "-end with-". This worked, even if it is not the proper way to get
> relative reference.
>
> How can I (again) choose whether a macro is recorded using relative or
> absolute reference?
>
> Thanks!
>
> Alex
>
>
> --
> Ingeniero1
> ------------------------------------------------------------------------
> Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
> View this thread: http://www.excelforum.com/showthread...hreadid=510161
>
>

Are you sure that works... Using the X closes the toolbar and keeps it from
re-apperaing. I don't use this menu but as memory serves I believe that using
the X is how Ingeniero1 would have gotten into this problem in the first
place. Unless I am missing something...
--
HTH...

Jim Thomlinson


"Gary L Brown" wrote:

> Open up the toolbar...
> Tools>Customize>Toolbars
> Select 'Stop Recording'
> Close the 'Stop Recording' button by 'x'ing out of it. It should re-appear
> from now on.
>
> or
>
> run this macro called TryMe...
>
> '/======================================/
> Public Sub TryMe()
> Application.CommandBars("Stop Recording").Visible = True
> End Sub
> '/======================================/
>
> and then close the 'Stop Recording' button by 'x'ing out of it. It should
> re-appear from now on.
>
> HTH,
>
> --
> Gary Brown
> gary_brown@ge_NOSPAM.com
> If this post was helpful, please click the ''Yes'' button next to ''Was this
> Post Helpfull to you?''.
>
>
> "Ingeniero1" wrote:
>
> >
> > When I used to click-on or select the record macro button, a small icon
> > used to pop-up that allowed me to select whether I wanted absolute or
> > relative reference. For some reason, the icon does not display anymore,
> > and I don't know how to record a macro in relative; it automatically
> > records in absolute.
> >
> > I needed a macro to work using the two cells next to wherever the
> > cursor was placed, and I ended up having to edit the recorded macro by
> > replacing the absolute cell references with "-with selection-" and
> > "-end with-". This worked, even if it is not the proper way to get
> > relative reference.
> >
> > How can I (again) choose whether a macro is recorded using relative or
> > absolute reference?
> >
> > Thanks!
> >
> > Alex
> >
> >
> > --
> > Ingeniero1
> > ------------------------------------------------------------------------
> > Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
> > View this thread: http://www.excelforum.com/showthread...hreadid=510161
> >
> >

You're right! My apologies.
Thanks for the clearification.
--
Gary Brown
gary_brown@ge_NOSPAM.com


"Jim Thomlinson" wrote:

> Are you sure that works... Using the X closes the toolbar and keeps it from
> re-apperaing. I don't use this menu but as memory serves I believe that using
> the X is how Ingeniero1 would have gotten into this problem in the first
> place. Unless I am missing something...
> --
> HTH...
>
> Jim Thomlinson
>
>
> "Gary L Brown" wrote:
>
> > Open up the toolbar...
> > Tools>Customize>Toolbars
> > Select 'Stop Recording'
> > Close the 'Stop Recording' button by 'x'ing out of it. It should re-appear
> > from now on.
> >
> > or
> >
> > run this macro called TryMe...
> >
> > '/======================================/
> > Public Sub TryMe()
> > Application.CommandBars("Stop Recording").Visible = True
> > End Sub
> > '/======================================/
> >
> > and then close the 'Stop Recording' button by 'x'ing out of it. It should
> > re-appear from now on.
> >
> > HTH,
> >
> > --
> > Gary Brown
> > gary_brown@ge_NOSPAM.com
> > If this post was helpful, please click the ''Yes'' button next to ''Was this
> > Post Helpfull to you?''.
> >
> >
> > "Ingeniero1" wrote:
> >
> > >
> > > When I used to click-on or select the record macro button, a small icon
> > > used to pop-up that allowed me to select whether I wanted absolute or
> > > relative reference. For some reason, the icon does not display anymore,
> > > and I don't know how to record a macro in relative; it automatically
> > > records in absolute.
> > >
> > > I needed a macro to work using the two cells next to wherever the
> > > cursor was placed, and I ended up having to edit the recorded macro by
> > > replacing the absolute cell references with "-with selection-" and
> > > "-end with-". This worked, even if it is not the proper way to get
> > > relative reference.
> > >
> > > How can I (again) choose whether a macro is recorded using relative or
> > > absolute reference?
> > >
> > > Thanks!
> > >
> > > Alex
> > >
> > >
> > > --
> > > Ingeniero1
> > > ------------------------------------------------------------------------
> > > Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029
> > > View this thread: http://www.excelforum.com/showthread...hreadid=510161
> > >
> > >

Jim,

This,
"Click on Tools -> Customize -> Toolbars and Check Stop Recording. The tool
bar you are refering to should pop up. Now record a macro, and click stop
(not close) on the stop recording menu. The menu should disappear. It will
now come back in the future..."

worked fine - Thank you!

Alex