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

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

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

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

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

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

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