View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
 
Posts: 486
Default Absolute or Relative reference - no longer a choice!

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