Custom Tab in Office Ribbon – How to Create Your Own

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

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

  1. 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.
  2. In the dialog that appears, select New Tab to create a new Tab.
  3. 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.
  4. Now click on the New Group and click Rename and type a name that you like.
  5. 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.
  6. Adding Commands to the New Tab

  7. At the top of the left column, you would see a drop down with default value as Popular Command. Change it to Macro.
  8. Important: Confirm that on the right column, your new newly created Group under your group is selected and click Add.
  9. Select the macro name on the right column and Rename it and select any Icon.
  10. Click OK to close the dialog

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.

Do you want to learn Web Scraping in ONE HOUR?

Sign-up now!

Leave a Reply

Your email address will not be published. Required fields are marked *

More To Explore

Ready To

Say bye to the boring courses that put you to sleep immediately.

Learn how to monitor online store prices, save data to CSV file, and even send mail alerts—all of this in less than 1 hour!

Enter your details to receive your invite for FREE.

small_c_popup.png

Get Free Material Now

Learn how we helped so may people Learn Python and land a job!