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

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

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

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

Jim Thomlinson


"mathew" wrote:

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

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

Start recording a macro, then goto ToolsCustomise 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)

"mathew" wrote in message
...
How do you get Excel to record a macros using relative refernce mode?

How do you get Excel to record a macros using relative refernc
 

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

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"mathew" wrote:

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

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

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

--
Regards,
Tom Ogilvy


"mathew" wrote in message
...
How do you get Excel to record a macros using relative refernce mode?