What is a Macro?
The word
MACRO comes from an old computer tool: the macro assembler. The
macro assembler would allow a programmer to combine a sequence of
instructions into a single statement. Combining a series of steps into a
working program meant that tedious, repetitive tasks could be automated.
Microsoft
Office 2010 uses Visual Basic for Applications (VBA) to create
Macros. Making a Macro can be as simple as recording the mouse clicks as
you walk through a series of steps or instructions in Word, Excel,
PowerPoint or Access. The Macro recorder combines your steps into a
single program.
Your Macro can
be set up so that it will run whenever you click a custom Macro button
on the Ribbon. Macros can be assigned to a command button as well.