Microsoft Office Tutorials and References
In Depth Information
Assign a Macro to the Ribbon
Chapter 11: Learning VBA Basics
Add a Command
1 Click the Choose
Commands From
drop-down arrow, and
select Macros.
2 Click the macro you want
to add to the Ribbon.
3 Click Add.
1
3
Excel adds the macro to
the tab.
4 Click OK.
2
4
Excel adds the new group
and command to the
Ribbon.
More Options!
When it assigns a name to a Ribbon
macro button, Excel uses the general form
Workbook!Macro , where Workbook is the
name of the workbook that contains the
macro, and Macro is the name of the macro.
To use a shorter name, right-click any part of
the Ribbon and click Customize the Ribbon to
display the Customize Ribbon tab. Click the
macro button, click the Rename button, type
a new name, and then click OK.
Reverse It!
Right-click any part of the Ribbon and
then click Customize the Ribbon to
display the Excel Options dialog box
with the Customize Ribbon tab
displayed. To restore a tab, click the
tab, click Reset, and then click Reset
Only Selected Ribbon Tab. To remove
all customizations, click Reset and
then click Reset All Customizations.
 
Search JabSto ::




Custom Search