Datasheet

Assign a Macro to the
Quick Access Toolbar
Y
ou can assign a macro to the Excel Quick Access
toolbar. You can execute macros assigned to the
Quick Access toolbar using a shortcut key or the
Macro dialog box; however, using the Quick Access
toolbar means you can access the macros by clicking the
appropriate button.
When you add a button to the Quick Access toolbar, you
can specify whether it should appear on the toolbar of all
Excel workbooks or only on the Quick Access toolbar in
the workbook you specify. By default, the button appears
in all workbooks. If you have placed your macro in the
Personal Macro Workbook, you will probably want your
macro button to appear in all workbooks. If your macro is
only available to a single workbook, your macro button
should only appear on the Quick Access toolbar for that
workbook.
You can use the Customize the Quick Access Toolbar
pane of the Excel Options dialog box to add a macro
button to the Quick Access toolbar. The Customize the
Quick Access Toolbar pane has a number of options you
can set. You can use the Modify button to specify the
button you want to use to represent your macro. You can
specify where on the Quick Access toolbar your button
appears and whether the Quick Access toolbar appears
above or below the Ribbon. You can click the Reset
button to return the Quick Access toolbar to its default
state.
Deleting a macro does not remove the macro button from
the Quick Access toolbar. You use the Remove button on
the Customize the Quick Access Toolbar pane of the Excel
Options dialog box to remove a macro button.
1 Click Customize Quick Access Toolbar and then click
More Commands.
The Excel Options dialog box appears.
2 Click here and then click Macros.
3 Click here and then click the workbook in which the
button should appear.
4 Click the macro you want to assign to the Quick
Access toolbar.
5 Click Add.
•
The macro appears in the box on the right. Macros
display on the Quick Access toolbar in the order
shown here.
•
Click to move the macro up.
•
Click to move the macro down.
6 Click Modify.
•
Click if you want the Quick Access toolbar to appear
below the Ribbon ( changes to ).
1
1
3
4
6
5
2
Assign a Macro to the Quick Access Toolbar
16
04_132302 ch01.qxp 7/27/07 9:20 PM Page 16