It is very easy to Create a Custom Tab in Microsoft Office Ribbon — works with Microsoft Word, Microsoft Excel, and other office products. You can add your favorite command shortcuts and macro shortcuts to it.
You can also add shortcuts to existing tabs too.
In this example, we will create a Custom Tab in Microsoft Office Ribbon add a shortcut to a Macro, but you can use any of the functionalities like Save, Print, etc.
Create a New Tab and New Group
- Right-click anywhere on the Ribbon and select Customize the Ribbon. You will see the dialog seen earlier in the post where we talked about Enabling Developer Toolbar.
- In the dialog that appears, select New Tab to create a new Tab.
- In the same diablog, select the tab name in the right column that you just created, and this time click New Group to create a new group.
- Now click on the New Group and click Rename and type a name that you like.
- Then select New Group and click Rename to rename the group. In this Rename dialog, you can even assign an icon for the group. This would be a good place to logically group functionalities. This is NOT the name of the macro.
- At the top of the left column, you would see a drop down with default value as Popular Command. Change it to Macro.
- Important: Confirm that on the right column, your new newly created Group under your group is selected and click Add.
- Select the macro name on the right column and Rename it and select any Icon.
- Click OK to close the dialog
Adding Commands to the New Tab
Congratulations! You just added a new Tab with a button that executes a macro. Wasn’t it easy to create a Custom Tab in Microsoft Office Ribbon?
How was your experience? Did you find it easy? Let us know in the comments section below.