CODEWITHSUNDEEP
excelribbonvba
Josh
Josh

Reputation: 4622

VBA control over the ribbon?

I am in the process of creating a VBA add-in for Excel 2010, and I used the "Custom UI Editor for Microsoft Office" tool to create my own ribbon. However, I would like to give the user the option to load my add-in without displaying the ribbon, or with different parts of the ribbon visible.

With menus, I know you can completely control them programmatically, but ribbons seem to work differently.

Is there a way in VBA to not load my customUI.xml ribbon tabs on startup?
Is there a way to remove items from (or add items to) these tabs at runtime?

Upvotes: 3

Views: 15793

Answers (1)

Scott Holtzman
Scott Holtzman

Reputation: 27249

here is a whole slew of help on this subject Awesome Ribbon Help. I think points 2 and 3 are of particular interest to you.

Upvotes: 8

Related Questions