| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to record macro with relative addressing in Excel 2000 | Excel Discussion (Misc queries) | |||
| Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
| Macros - Relative cells in Excel | Excel Programming | |||
| Excel Relative Macros | Excel Programming | |||
Linear Mode
