Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Excel 2007 Table-Driven Ribbon Customizer


posted by Mike Alexander
Mon, Jan 14 2008

Downloads: 115
File size: 87.5kB
Views: 537
Excel 2007 Table-Driven Ribbon Customizer
Filed under: ,
A while back, I built a table-driven ribbon customizer utility for Excel 2007.

 

The gist is of the utility is this: 

 

You fill in a table specifying the custom buttons you want and which tabs you want them on.  Then the utility automatically builds the custom XML and adds it to a new workbook or existing workbook, effectively applying your Ribbon customizations without writing one line of code.

 

I've also made it so that the call-back functions are also created and added, so the buttons work right away!  The source code is open for anyone who wants to build on this and create a better table-driven Ribbon Customizer.

 

 

Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.