Customise Ribbon

[Richard Gavey]

I have previously assembled numerous spreadsheets to help me with design, costing & invoicing in my sole trader electrical business.

These were mostly created in Excel 95, XP & 2003.

I am currently running Excel 2013, but have never got to grips with ribbon editing. To overcome this, I also have Excel 2003 & File Format Converter running on my system, and use that to modify buttons, controls & menus as required.

With Excel 2003 about to go off the radar, I thought it was about time I learned how to cope with the dreaded ribbon.

I want to add several macros to a custom ribbon tab & put them into various cascading buttons/icons as shown in attached jpeg.

Any ideas how to do this

[#2]

Get hold of Ken Puls's book on the ribbon: https://www.excelguru.ca/blog/2008/01/10/an-excerpt-from-ribbonx-customizing-the-office-2007-ribbon/
And visit Ron de Bruin's website which has many examples: http://www.rondebruin.nl/win/section2.htm

[#3]

Get hold of Ken Puls's book on the ribbon: www.excelguru.ca/blog/2008/01/10/an-excerpt-from-ribbonx-customizing-the-office-2007-ribbon/
And visit Ron de Bruin's website which has many examples: www.rondebruin.nl/win/section2.htm