Add Your Own Icon to an Excel Custom Ribbon Tab

Are you building custom tabs for your workbooks yet? Last year, I wrote a couple of articles about custom tabs:

In the screen shot below, you can see the custom tab that appears on the Ribbon when the Order Form workbook opens. The buttons make it easy to clear the data entry cells, and print a completed order form.

ribbonmacros17

Create an Icon

Today, you’ll see how to create your own icon, instead of using the built-in ones. You don’t need any artistic skills to create a simple icon, as you can tell from my screen shot below.

ribboncustomicon03

For this tutorial I used the Arrow tool in MS Paint, to create a “Home” button. Usually though, I draw them in Excel, then take a screen shot using Snagit. Yes, Excel is good for almost everything!

ribboncustomicon05 

Add a Button

After you’ve created your icon masterpiece, you can use the Custom UI Editor tool to modify the Ribbon code, and insert the icon image.

ribboncustomicon02

The button will run a macro, “GoOrder”,  that activates the Order sheet in the workbook. This is the new section in the XML code, to show the new button.

ribboncustomicon01

Video: Add Your Own Icon to the Ribbon

Watch this short video, to see the steps for adding your own custom icon to a tab in the Ribbon.

Download the Sample File

To see how the custom icon is set up, you can visit the Add a Custom Tab page on my Contextures site. There are detailed written instructions for creating a custom tab, and adding your own icon to a button. You can also download the sample file, to help you get started.

________________