How do you get Excel to record a macros using relative refernce mo

J

Jim Thomlinson

When you record a macro a Stop Recording Toolbar should come up. If it does
not then add the toolbar by selecting Tools Customize... On that toolbar is a
button for relative refence.
 
B

Bob Phillips

Start recording a macro, then goto Tools>Customise and select the
Toolbars tab, then check the Stop Recording checkbox


And don't close it by hitting the "X" when recording a macro or you will
lose it again.


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
M

mathew

Jim: I know it was a simple questions! Thank you for the answer, you saved
me lots of time!
 
T

Tom Ogilvy

the stop recording toolbar has two buttons. The right button toggles
between absolute and relative recording.
 

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

Similar Threads

Macro warning in word 1
Need Help with Macro Security 1
Merging from an Excel file with graphics 1
referencing controls in userform from a different workbook 2
how to setup web service reference in excel 2007 vba? 0
referncing software in academic writing 0
I cannot record a macro in relative mode. The button never shows. 1
How to use Macros 1

Top