Absolute or Relative reference - no longer a choice!

I

Ingeniero1

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
 
J

Jim Thomlinson

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

Gary L Brown

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,
 
J

Jim Thomlinson

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

Ingeniero1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top