Microsoft Office Tutorials and References
In Depth Information
If you add more than one macro button to the Quick Access Toolbar or if you want to
change the button that represents your macro on the Quick Access Toolbar, you can select
a new button from more than 160 options. To assign a new button to your macro, click the
macro item in the Customize Quick Access Toolbar pane and click the Modify button to
display your choices. Click the symbol you want, type a new text value to appear when a
user points to the button, and then click OK twice (the first time to close the Modify Button
dialog box and the second to close the Excel Options dialog box).
Finally, you can have Excel run a macro when you click a shape in your workbook. Assigning
macros to shapes enables you to create “buttons” that are graphically richer than those
available on the Quick Access Toolbar. If you’re so inclined, you can even create custom
button layouts that represent other objects, such as a remote control. To run a macro
when you click a shape, right-click the shape, and then click Assign Macro on the
shortcut menu that opens. In the Assign Macro dialog box, click the macro you want to run
when you click the shape, and then click OK.
Important When you assign a macro to run when you click a shape, don’t change the name of
the macro that appears in the Assign Macro dialog box. The name that appears refers to the
object and what the object should do when it is clicked; changing the macro name breaks that
connection and prevents Excel from running the macro.