Microsoft Office Tutorials and References
In Depth Information
Add a button to
RUN A MACRO
You can create a button to run your macro. For a
common task such as applying a format, a button can
speed up your work and spare you the annoyance of
repeatedly opening a dialog box and making the same
To assign a macro to a button, you must first create
the macro, as explained in Task #99. Then you
choose a button to represent the macro and move
the button to the Quick Access toolbar. Once the
button is on the Quick Access toolbar, simply click
the button to run the macro.
As an alternative to running your macro with a
button, press Alt+F8 to open the Macro dialog box.
Click the macro name and then click the Run button.
To change the shortcut key, while in the Macro
dialog box, click Options. The Macro Options dialog
box appears. Type a new shortcut key. You can also
use the Macro dialog box to delete your macro by
clicking the macro and then clicking the Delete
Open a workbook containing
macros you created.
Note: See Task #99 for more on
Click here and select More
The Excel Options dialog box
Click here and select Macros.
Click here and select the name of
Excel precedes the name with
the word “For.”
Click the macro you want to add
to the Quick Access toolbar.
Excel moves the macro to the
box on the right.