Datasheet

16
6
1
1
2
4
5
3
The Excel Options dialog box appears.
2 Click the down arrow and then select
Macros.
3 Click the down arrow and then select
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.
6 Click Modify.
1 Click the Customize Quick Access
Toolbar button and then select More
Commands.
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 simply
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 probably want your macro button to
appear in all workbooks because the macro is available to
all workbooks. If your macro will be available only to a
single workbook, your macro button should appear only on
the Quick Access toolbar for that workbook.
You use the Customize the Quick Access Toolbar page of
the Excel Options dialog box to add a macro button to the
Quick Access toolbar. 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. When you press the button for
a deleted macro, you receive an error message. Use the
Remove button on the Customize the Quick Access
Toolbar page of the Excel Options dialog box to remove a
macro button.
Assign a Macro to the
Quick Access Toolbar
03_591598-ch01.indd 1603_591598-ch01.indd 16 6/11/10 1:41 PM6/11/10 1:41 PM