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 indicating that you can click it to run the macro.