CODEX

How to Build a Custom Ribbon in Excel

Using XML and VBA

Andrew Moss
Jan 25 · 14 min read

The wrong way to build a system

The shadowed area illustrates how worksheet space can be wasted unnecessarily.

Download the example file

Workbook composition

The best way of building a ribbon

customUI14.xml file

customUI

ribbon

tabs

tab

What does this look like in practice?

Adding controls and attributes

group

Attributes

Defining controls

button

menu

separator

buttonGroup

togglebutton

dropDown

item

splitButton

checkbox

gallery

editBox

box

labelControl

contexualTabs

Making the ribbon functional

“A callback is a function that executes when the user interacts with the ribbon XML control.”

Hadi Brais — Stack Overflow

Final words

CodeX

Everything connected with Tech & Code

Andrew Moss

Written by

I mainly focus on Excel-related content in my articles, often providing example workbooks to download, too. https://www.linkedin.com/in/andrewcharlesmoss

CodeX

CodeX

Everything connected with Tech & Code

Andrew Moss

Written by

I mainly focus on Excel-related content in my articles, often providing example workbooks to download, too. https://www.linkedin.com/in/andrewcharlesmoss

CodeX

CodeX

Everything connected with Tech & Code

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store