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

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

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

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



"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...
ToolsCustomizeToolbars
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

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. Th
tool
bar you are refering to should pop up. Now record a macro, and clic
stop
(not close) on the stop recording menu. The menu should disappear. I
will
now come back in the future...-"

worked fine - Thank you!

Ale

--
Ingeniero
-----------------------------------------------------------------------
Ingeniero1's Profile: http://www.excelforum.com/member.php...nfo&userid=402
View this thread: http://www.excelforum.com/showthread.php?threadid=51016