| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does it mean to record the macro
Hi,
What does it mean to record the macro with relative addressing switched on? And how can I switch it on. Thanks Liz |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does it mean to record the macro
When you record a macro normally it will record the cell references by their
address. When recorded with relative referencing then it will record how you moved relative to some starting point. To switch it on when you start recording a macro the Stop Recording tool bar should come up (if not then repy back and we can get it back on for you). There are 2 buttons on the bar. The first is Stop (Blue Square). The second is for Relative Referencing. Click this button and the macro will record with relative references... -- HTH... Jim Thomlinson "Liz" wrote: Hi, What does it mean to record the macro with relative addressing switched on? And how can I switch it on. Thanks Liz |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does it mean to record the macro
Thanks a lot
"Jim Thomlinson" wrote: When you record a macro normally it will record the cell references by their address. When recorded with relative referencing then it will record how you moved relative to some starting point. To switch it on when you start recording a macro the Stop Recording tool bar should come up (if not then repy back and we can get it back on for you). There are 2 buttons on the bar. The first is Stop (Blue Square). The second is for Relative Referencing. Click this button and the macro will record with relative references... -- HTH... Jim Thomlinson "Liz" wrote: Hi, What does it mean to record the macro with relative addressing switched on? And how can I switch it on. Thanks Liz |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does it mean to record the macro
I use to see that tool bar but now I can't see it. Please help.
Thanks Liz "Jim Thomlinson" wrote: When you record a macro normally it will record the cell references by their address. When recorded with relative referencing then it will record how you moved relative to some starting point. To switch it on when you start recording a macro the Stop Recording tool bar should come up (if not then repy back and we can get it back on for you). There are 2 buttons on the bar. The first is Stop (Blue Square). The second is for Relative Referencing. Click this button and the macro will record with relative references... -- HTH... Jim Thomlinson "Liz" wrote: Hi, What does it mean to record the macro with relative addressing switched on? And how can I switch it on. Thanks Liz |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does it mean to record the macro
Hi Liz
Start to record a new Macro with ToolsMacroRecord New MacroOK then click ViewToolbarsclick on Stop Recording The floating toolbar will appear. Use the Blue Stop button to stop recording, not the black X at the top right of the bar, otherwise it will disappear again. -- Regards Roger Govier "Liz" wrote in message ... I use to see that tool bar but now I can't see it. Please help. Thanks Liz "Jim Thomlinson" wrote: When you record a macro normally it will record the cell references by their address. When recorded with relative referencing then it will record how you moved relative to some starting point. To switch it on when you start recording a macro the Stop Recording tool bar should come up (if not then repy back and we can get it back on for you). There are 2 buttons on the bar. The first is Stop (Blue Square). The second is for Relative Referencing. Click this button and the macro will record with relative references... -- HTH... Jim Thomlinson "Liz" wrote: Hi, What does it mean to record the macro with relative addressing switched on? And how can I switch it on. Thanks Liz |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does it mean to record the macro
I can't find the toolbar for stop recording. I use to get it on my screen
the movement I click on Recording new macro but I don't see it no more. How can I bring it back on my screen as toolbar. Thanks Liz "Jim Thomlinson" wrote: When you record a macro normally it will record the cell references by their address. When recorded with relative referencing then it will record how you moved relative to some starting point. To switch it on when you start recording a macro the Stop Recording tool bar should come up (if not then repy back and we can get it back on for you). There are 2 buttons on the bar. The first is Stop (Blue Square). The second is for Relative Referencing. Click this button and the macro will record with relative references... -- HTH... Jim Thomlinson "Liz" wrote: Hi, What does it mean to record the macro with relative addressing switched on? And how can I switch it on. Thanks Liz |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What does it mean to record the macro
ToolsCustomizeToolbars.
Select the Stop Recording Toolbar and OK your way out. Follow Jim's advice from that point. Gord Dibben MS Excel MVP On Thu, 15 Mar 2007 10:10:15 -0700, Liz wrote: I can't find the toolbar for stop recording. I use to get it on my screen the movement I click on Recording new macro but I don't see it no more. How can I bring it back on my screen as toolbar. Thanks Liz "Jim Thomlinson" wrote: When you record a macro normally it will record the cell references by their address. When recorded with relative referencing then it will record how you moved relative to some starting point. To switch it on when you start recording a macro the Stop Recording tool bar should come up (if not then repy back and we can get it back on for you). There are 2 buttons on the bar. The first is Stop (Blue Square). The second is for Relative Referencing. Click this button and the macro will record with relative references... -- HTH... Jim Thomlinson "Liz" wrote: Hi, What does it mean to record the macro with relative addressing switched on? And how can I switch it on. Thanks Liz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UNABLE TO RECORD A MACRO | Excel Worksheet Functions | |||
| Record New Macro | Setting up and Configuration of Excel | |||
| Unable to record Macro | Excel Discussion (Misc queries) | |||
| Unable to Record Macro | Excel Discussion (Misc queries) | |||
| Unable to Record Macro | Excel Discussion (Misc queries) | |||
Hybrid Mode
