Ribbons and Macro Buttons

**ashleys.nl** · 09-29-2011, 03:05 PM

Hello Everyone,

I'm not sure if I should post this here or under the macro section.

I've created an excel workbook which has several macros within in it. I've linked all these macros to a custom ribbon that I have created and on this ribbon I have than created a custom button for each macro. It works great for me. but when other users open the Excel file they cannot see the custom ribbon that I have created. Instead they must go through the hassel of import my custom settings by finding a customization file on the network.

So my question is ... is there a way to imbed this Ribbon into the workbook so that all users would see it automatically upon opening the workbook?

Thanks in advance.

-Ashley

**Bob Phillips** · 09-29-2011, 03:21 PM

Tell us more about how you built it.

**ashleys.nl** · 09-30-2011, 10:21 AM

Wasn't much too it really, I just built it by right clicking on the existing Ribbons and going into the customization settings.

To Create the ribbon itself there isn't any ascociate code or anything. Its just a built in option on Excel 2010

**quekbc** · 09-30-2011, 10:41 AM

In this case, the only method I know of is to edit the XML code behind your spreadsheet. To do this, I use a software called CustomUI (free).

This website might be of some interest to you.
http://www.rondebruin.nl/ribbon.htm

**ashleys.nl** · 09-30-2011, 02:46 PM

Thanks quekbc , I'll give this a try when I get around to it.

Cheers

**royUK** · 10-01-2011, 02:25 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save