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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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)
 
Jim: I know it was a simple questions! Thank you for the answer, you saved
me lots of time!
 
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

Refeencing a check box on an Excel sheet 6
referencing controls in userform from a different workbook 2
I cannot record a macro in relative mode. The button never shows. 1
Workday Function in VBA 3
VB to specify criteria then paste to a new worksheet 1
how to refernce a folder? 35
Do I have a compatability issue here,,, 1
Finding row number at the bottom of a block of data 2

Back
Top