Microsoft Office Tutorials and References
In Depth Information
Topic A: Recording and running macros
Topic A: Recording and running macros
This topic covers the following Microsoft Office Specialist objectives for exam 77-887:
Word Expert 2010.
#
Objective
5.1
Apply and manipulate macros
5.1.1
Record a macro
5.1.2
Run a macro
5.1.3
Apply macro security
5.2
Apply and manipulate macro options
5.2.1
Run macros when a document is opened
5.2.2
Run macros when a button is clicked
5.2.3
Assign a macro to a command button
5.2.4
Create a custom macro button on the Quick Access Toolbar
Working with macros
Explanation
While working in Word, you might have to perform repetitive tasks—for example,
inserting or formatting tables that you use often. A macro is a collection of actions used
to automate complicated, lengthy, or repetitive tasks. There are two ways to create a
macro. The easiest method is to use the macro recorder to identify the actions. The
other method is to enter Visual Basic code in the Microsoft Visual Basic for
Applications editor.
Creating macros
To create a macro by using the macro recorder:
1
On the View tab, in the Macros group, click Macros and choose Record Macro
to open the Record Macro dialog box, shown in Exhibit 3-1.
2
In the Macro name box, enter a name for the macro.
3
Using the “Store macro in” list, specify whether you want to store the macro in
the current document only or make the macro available for all documents.
4
In the Description box, enter a description of the macro.
5
(Optional) Create a macro button on the Quick Access toolbar or assign a
keyboard shortcut to the macro.
Click Button to open the Word Options dialog box. Under “Choose
commands from,” select the macro and click Add. Click Modify to edit the
button’s icon. Click OK to close the dialog box.
Click Keyboard to open the Customize Keyboard dialog box. Press the
desired keys to enter the shortcut in the “Press new shortcut key” box.
Click Assign, and then click Close to close the dialog box.
6
Click OK to close the Record Macro dialog box.
Search JabSto ::




Custom Search