In a previous screen-cast, I showed the basic steps to customize a ribbon and call a VBA function from the XML that defines the customization. In this video I go one step further - I show a more interesting ribbon customization, and I show how to deploy as a VBA Add-In.
In the XML that defines the customized ribbon, there are identifiers that you use to identify existing ribbon artifacts. For instance, if you are modifying the Data Tab, there is an identifier, TabData, that you use to indicate which tab you are customizing. The video shows how to look up the appropriate identifiers in a downloadable spreadsheet. You can download the list of available identifiers at http://www.microsoft.com/download/en/details.aspx?id=6627.
In addition, in the XML, you can use image identifiers to access a large number of stock icons that you can use in the ribbon. You can find the complete list of images in a macro enabled Word document at http://www.microsoft.com/download/en/details.aspx?id=21103.
The first video in this series is Using Open XML Package Editor to Create a Ribbon Button that runs a VBA Function.
This is a real-world scenario - you need to implement some sophisticated manipulation of Excel tables