Easy Excel Ribbon

  • Version
  • 1'382 Downloads
  • 430KB File Size
  • August 23, 2020 Updated
  • 0 Number of comments
  • Rating

Template Updated August 16, 2020:
The updated versions now works in all countries with different data settings

If you write macros, try this template.

A ribbon tab is the most modern and professional user interface to trigger macros. Businesses are much more likely to endorse Excel projects with a custom ribbon tab.

Ribbon created is shareable

This ribbon tab is saved in the workbook itself so you can email to whoever you like and it will work the exact same for them. Whereas Microsoft Excel’s customize ribbon feature saves the ribbon to your computer so it isn’t shareable and is not useful.

Creating your own ribbon in minutes not weeks

Previously developing a shareable Excel ribbon tab requires either XML coding or reading a complex manual preventing 99.9% of Excel users from doing this.

My mission is to give any Excel user the ability to develop a custom ribbon in minutes. Using this template you simply fill out a simple spreadsheet to create your own ribbon in a couple of minutes. It’s that easy.

How to create a custom ribbon?

Follow these steps to create your own ribbon:

Step 1. Download an open this template

Step 2.  Fill out the sheet below
• Immediately see changes to your ribbon as you fill out this workbook.
• For tips on filling out each column, hover your mouse over the column heading.
• There is also an inbuilt icon tool you can use to find icons within a database of more than 7000 icons.

Easy Excel Ribbon Create Custom Ribbon

Step 3.  Click the ‘Done’ button

Step 4.  Add code for each of your buttons actions.  

Click a button (or menu item) to go to the Button_Click procedure where you add code.  Add code to this procedure to set button actions.

How useful was this template?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 5

No votes so far! Be the first to rate this template.

We are sorry 🙁

Help us improve!

How we can improve this template?

Automate Sending Emails From Excel

225 KB / 2557 downloads
View Comments
There are currently no comments.