Search code examples
exceloffice-2010vba

Package a Ribbon with a Custom VBA Add In for Microsoft Office

I am working with Excel 2010 but I assume the idea is constant accross all of Office 2010.

I am making an Add in to have some VBA Macros that will work with all of my files and would like to make a ribbon that has buttons bound to these macros. I know how to make a ribbon through Excel Options --> Customize Ribbon but I would like to make one that is shown whenever the Add In is active. This is so I can distribute the Add in with an easy way to run the macros.

Is there a way I can do this? Thanks

UPDATE:

I have read into it and with what I have at my disposal here (Office 2010 and notepad) I am going to have to make the ribbon as an XML document and then put that with my xlam file. I am just not sure on the specifics at this point.

Solution

  • I ended up doing it by hand based on this answer.

    Worked well, just a little tricky working with zipping the Excel Files. Never Unzip the entinre file, just open it with explorer and copy files into it and it worked well!