Datasheet

Assigning Macros to the Quick Access Toolbar
710
Assigning Macros to the Quick Access Toolbar
Instead of running a macro by selecting it in the Macro dialog box or by
pressing shortcut keys you assign to it, you can assign the macro to a
custom button on the Quick Access toolbar and then run it by clicking
that custom button.
To assign a macro to a custom button on the Quick Access toolbar, you
follow these steps:
1. Click Office Button | Excel Options | Customize or press Alt+FIC to
open the Customize tab of the Excel Options dialog box.
2. Click Macros in the Choose Commands From drop-down list box.
Excel lists the names of the all the macros created in the current
workbook and saved in the PERSONAL.XLSB workbook in the Choose
Commands From list box.
3. Click the name of the macro to add to a custom button on the Quick
Access toolbar in the Choose Commands From list box and then click
the Add button.
4. Click OK to close the Excel Options dialog box.
After you close the Excel Options dialog box, a custom button with a generic
macro icon (picturing a standard command flowchart icon) appears on the
Quick Access toolbar. To see the name of the macro assigned to this custom
macro button as a ScreenTip, position the mouse pointer over the button. To
run the macro, click the button.
Keep in mind that you can also assign macros to the graphic objects you
add to your worksheet, including shapes you draw, clip art, and pictures you
import. To assign a macro to a graphic object, right-click it and then click the
Assign Macro option on its shortcut menu. Then click the name of the recorded
macro to run in the list box of the Assign Macro dialog box and click OK.
Thereafter, when you position the mouse pointer over the graphic object,
the pointer becomes a hand with a pointing index finger (just like when you
assign a hyperlink to a graphic — see Book IV, Chapter 2), indicating that
you can click it to run the macro.
36_037385 bk08ch01.qxp 11/17/06 11:08 AM Page 710