Customise ribbon when installing Add-In

[Seraph84]

Ok, so I got my macro working as it should and I’ve saved the template as an Add-in to distribute to the rest of my team.

What I would like to do now is have the ribbon automatically customised when everyone else installs the add-in, so they don’t have to individually have to add a new group to use the macro. Is this possible?

Ideally I would like to have the Add-in assigned to the following path Home>Custom Group>Macro, and perhaps have the smiley face icon assigned to it as well (the macro is really going to save us a lot of time so it’ll make everyone happy!)

How do I go about this?

[quekbc]

Hi Seraph84,

For that you would need to modify the CustomUI.xml file in the Excel spreadsheet.

Perhaps this website would be of some interest to you.
http://www.rondebruin.nl/ribbon.htm

[Seraph84]

Thanks for the link. Unfortunately the firewall at work is preventing me from downloading from those links.

Any other way I can do this? Like inserting the code into a another module maybe?

[quekbc]

Unfortunately, I don't know any method of editing Ribbons using VBA. To my (fairly limited) knowledge, it is not possible.

You would need to manually edit the CustomUI.xml code in the excel spreadsheet. I use a free software called CustomUI to do it. And you would need to learn some basic XML

[romperstomper]

If you don't mind the button ending up on the Addins tab, you can use the old Commandbars collection just as used in previous versions of Office.

[Seraph84]

So i managed to get this working. i downloaded the CustomUI Editor and did the neccessary addtions to my template. I then emailed the XML files that contain the changes to my work, and then used winzip to insert the files to my add-in template.

Been doing some reading, and there is no way of using VBA only to customise the ribbon with the later versions of Office.

Thanks for the links, its a big help!