How do you record a macro?

What is the use for a macro within Excel or any MS Office Program?

I appreciate any help you can give. Thanks!!

Jessica

Hi

Originally macro was a collection of commands written in special macro
language, which the user could invoke at will. Lately is this term often
used as synonym for VBA procedure, but for as much as I know, old macro
commands are supported too. In Excel, when you record a macro step-by-step,
really a procedure is created, but in Access is created an old-style macro.

To create a macro (Procedure) in Excel you can start macro recorder from
menu Tools.Macro.RecordNewMacro - all your actions are stored as VBA
comands, until you stop the Macro Recorder. Macros created in such way are
stored in workbooks module (those macros are available only from this
workbook), or in a module of Personal Macro Workbook (macros stored there
are available in any workbook, opened in this computer).
Or you activate VBA editor (Alt+F11), and write the VBA procedure yourself
(When there is no module ready, then from menu Insert.Module. And when you
have the module, then Insert.Procedure, type the name, and set type to Sub).

In VBA editor, you can edit macros, created by Macro Recorder, too. The
code, written by Macro Recorder, usually isn't optimal.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"JessicaHam" wrote in message
...
How do you record a macro?

What is the use for a macro within Excel or any MS Office Program?

I appreciate any help you can give. Thanks!!

Jessica

Hi Jessica

sounds like homework questions to me ...

so for Q1 ... have a look somewhere on the tools menu

and for Q2 ... here's some multiple choice options to get you started

A macro can be used for?
a) Automating repetative tasks
b) Extending the functioanlity of a program
c) Creating a menu driven workbook
d) All of the above

Cheers
JulieD


"JessicaHam" wrote in message
...
How do you record a macro?

What is the use for a macro within Excel or any MS Office Program?

I appreciate any help you can give. Thanks!!

Jessica