Forum Discussion
Richard Gavey
Jan 12, 2018Copper Contributor
Customise Ribbon
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
- JKPieterseSilver ContributorGet 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 - JKPieterseSilver ContributorGet 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