How to add buttons to a ribbon - EXCEL 2007

[avveerkar]

I have just switched over from Office2000 to 2007. I have written my own micros and stored in Personal.xlam in XLStart folder. Therefore they are available when I start EXCEL. In my earlier version of EXCEL I could customize the tool bar, add a customized button to the tool bar and then assign one of my micros to the button. Thus I could run any of my desired micros by just clicking the button. I want to do similar thing in EXCEL 2007. Edit a button image and design a button, put it on the ribbon ( under any tab - eg. Developer Tab ) and then assign the desired micro to the button. The button should be on the ribbon ( and not on the sheet ) so that it is always available whenever I start EXCEL.

Please help. Thanks

[TechRetard]

I had to do this when I created a custom menu in Outlook 2007 about a year ago and I used xml and c# programming in visual studio. Not sure if there is an easy way and I don't have a copy of 07 right now....check out this website and see if its plausible or too complicated for you
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[bentleybob]

If you don't want to write the code yourself, try RibbonCustomizer. (See pschmid.net). You can customize the ribbons (within limits).

If you just want the functionality and don't necessarily need it fully-customizable, you can of course add macros to the Quick Access Toolbar.

I do both, although it's certainly not nearly as good as Office 2003 customization.

[avveerkar]

I had to do this when I created a custom menu in Outlook 2007 about a year ago and I used xml and c# programming in visual studio. Not sure if there is an easy way and I don't have a copy of 07 right now....check out this website and see if its plausible or too complicated for you
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

Thanks TechRetard. That is a very good article. I have not worked with XML etc so far but something tells me that I better start now. Looks like my weekend is now booked for XML.
Veerkar

[avveerkar]

If you don't want to write the code yourself, try RibbonCustomizer. (See pschmid.net). You can customize the ribbons (within limits).

If you just want the functionality and don't necessarily need it fully-customizable, you can of course add macros to the Quick Access Toolbar.

I do both, although it's certainly not nearly as good as Office 2003 customization.

Thanks for your quick reply. RibbonCustomizer appears to be a good product. But I think I will go the XML way. Learning that perhaps will be more fun.
If not on ribbon, then how do you add your macros to Quick Access Toolbar? What I can see that you can move the components available on the ribbon to the QA Toolbar but I could not find out how to create buttons on the QA Toolbar to run your micros.

Veerkar

[Andy Pope]

For a set of comprehensive information on the ribbon see Ron de Bruin's site
http://www.rondebruin.nl/ribbon.htm

xl2003 commandbar customization should appear in the Add-in tab.

[avveerkar]

For a set of comprehensive information on the ribbon see Ron de Bruin's site
http://www.rondebruin.nl/ribbon.htm

xl2003 commandbar customization should appear in the Add-in tab.

Thank you Andy and thank you all. I can take it from here.

Veerkar

[bentleybob]

To add macros to your QAT, they need to be stored in your Personal.xlsb file. Then, click on the arrow at the right of the QAT, select More Commands, and, in the box at the top "Choose commands from" select Macros. You should find yours listed, and it's a simple matter of adding them where you want. Then you can click on it in the right-hand panel and Modify will become ungrayed, so you can change the icon. You are, unfortunately, limited in the selection but at least you have some options.