Microsoft Office Tutorials and References
In Depth Information
RUN A MACRO FROM AN ICON
RUN A MACRO FROM AN ICON
Challenge: You want an easy way to run a macro, and you don’t especially like
the options presented in “Run a Macro from a Button.” Can you run a macro
from an icon on a toolbar?
Solution: The process of setting up a macro to run from a toolbar icon changed
dramatically between Excel 2003 and Excel 2007. You have far more options
in Excel 2003.
Part
3
For Excel 2007
In Excel 2007, the only non-programmatic method for adding a macro button to
a toolbar is to add a button to the Quick Access toolbar. Follow these steps:
1.
Right-click anywhere in the ribbon and choose Customize Quick Access
Toolbar. Excel opens the Customize section of the Excel Options dialog.
2.
Open the Choose Commands From dropdown and select the fourth item,
Macros.
3.
Choose a macro from the left list box.
4.
Press the Add>> button in the center of the dialog.
5.
Use the up or down arrow button on the right side of the dialog to rearrange
the icon within the ribbon, if desired (Figure 114).
Figure 114. You can add an icon to the Quick Access toolbar and
adjust its location.
 
 
Search JabSto ::




Custom Search