What does a macro actually do
 

In excel if it is a Macro file that it updates all related workbooks. I do
not entirely understand this.

What does a macro actually do
 

Dear Robin

A macro is a recording of each command and action you perform to complete a
task. Later whenever you need to carry out that task in your worksheets you
just need to run the macro. They will always carry out the same steps in the
same order. Complex ones can be created using the VBE but simpler ones are
created by recording the macro. Try recording one from tools|Macro and view
the code to understand your actions...

If this post helps click Yes
---------------
Jacob Skaria


"Robin" wrote:

In excel if it is a Macro file that it updates all related workbooks. I do
not entirely understand this.

What does a macro actually do
 

Jacob,

Thank you. You explained that well.

"Jacob Skaria" wrote:

Dear Robin

A macro is a recording of each command and action you perform to complete a
task. Later whenever you need to carry out that task in your worksheets you
just need to run the macro. They will always carry out the same steps in the
same order. Complex ones can be created using the VBE but simpler ones are
created by recording the macro. Try recording one from tools|Macro and view
the code to understand your actions...

If this post helps click Yes
---------------
Jacob Skaria


"Robin" wrote:

In excel if it is a Macro file that it updates all related workbooks. I do
not entirely understand this.