Thread
:
Absolute or Relative reference - no longer a choice!
View Single Post
#
5
Posted to microsoft.public.excel.programming
Gary L Brown
external usenet poster
Posts: 219
Absolute or Relative reference - no longer a choice!
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
Reply With Quote
Gary L Brown
View Public Profile
Find all posts by Gary L Brown