Custom Ribbon Tab for Excel File

Have you created any custom tabs for your Excel files? I avoided that, as long as possible, but have finally started dabbling with the Ribbon code. And, the good news is that it’s not as dark and scary as I imagined.

Here is a screen shot of a sample file that I created, as an update to my Parts Database which has a UserForm for data entry.


When the file opens, it adds a custom tab to the Ribbon, with buttons to run the workbook’s macros.

You can download the sample file, and see the written instructions here: Getting Started With Excel Ribbon Custom Tabs

View and Edit Ribbon Code

To see the Ribbon code, without messing with the hidden parts of an Excel file, you can use the free tool – Custom UI Editor.


To get started, use the Custom UI Editor to take a look at a sample file or two. Then, you can copy some of the sample code into your own files, and tweak the labels and macro names, to match your workbook.

Watch the Video

To see the steps for opening and editing the Ribbon code with the Custom UI Editor, please watch this short video tutorial. The sample file and written instructions are here: Excel Ribbon Custom Tabs Intro

Or watch on YouTube: Excel Ribbon Custom Tab Introduction


You may also like...

4 Responses

  1. Andrew says:

    Hi Debra,

    Thanks so much for this useful information. I have a question: how would one go about removing these custom tabs. I have created one which now appears in every new workbook that I open and cannot remove it.

    Thanks in advance,


  1. January 22, 2013

    […] Custom Ribbon Tab for Excel File […]

  2. October 2, 2014

    […] Custom Ribbon Tab for Excel File – how to open and edit the Ribbon Code […]

Leave a Reply to Brett Gregory Cancel reply

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