Ch.4.2 Sound Byte: Programming for end users
Creating a Macro in Word
Add the Developer tab to the ribbon in Word Record a macro in Word to insert a table Run the macro
Before you can work with macros in Word or Excel, the __________ tab must be available.
Developer
Describe what a macro is and what it can do.
Macros are programs that automate common tasks. Macros make the performing of repetitive tasks simple. Macros can have hundreds of steps. VBA (Visual Basic for Applications) provides the programming functionality for macros in Microsoft Office.
What Is a Macro?
Small program that groups series of commands so they run as single command Best used to automate routine task or complex series of commands that must be run frequently Microsoft Office includes Visual Basic for Applications (VBA) to provide functionality for recording macros In VBA macros are also known as procedures Advantages of macros: Simplify complex tasks Reusable Can be edited and changed
Describe how to create a simple macro.
The code for the macro can be easily recorded and edited using tools found within Microsoft Office applications. Macros can be edited and reused. The Developer tab must be added to the ribbon to record macros.
Which of the following statements about macros is FALSE?
They can perform a maximum of five steps.
VBA stands for __________.
Visual Basic for Applications
A macro is __________.
a small computer program
The easiest way to automate a task in Word is to __________.
perform the task while recording a macro
