This article is simply a super great place to find links to the most used articles

• imageMso codes for customUI images
• [MS-CUSTOMUI]: Custom UI XML Markup Specification
• Absolute Path example of onAction
  • onAction=”‘L:\Directory1\Directory2\Spreadsheet name.xlam\’!MyFavFunctionInExcelsName”
  • and then you need to add a handler called MyFavFunctionInExcelsName(control As iRibbonControl)

There are some pretty cool “on the fly” programmatic things we can do with the VBA references like deleting “MISSING” references (which break code that is referenced UNDER these missing references- that is why they need to be fixed). But to do so requires that the user checks the box ‘Trust access to the VBA project object model’ which is buried deep (in typical Microsoft fashion). The Ribbon to check this manually is in the popup window accessed by File->Options->Trust Center->Macro Settings. Instead of writing code to tell the user what to do – why not get a registry change on all the target computers first. This article gives the *hint* on how to do that. I have 32bit Office (on purpose – so I don’t forget about those users) but everyone should have 64bit. So – there are a few registry keys that should get set.

Here’s a couple links that explain how to unzip and modify the OpenXML file hierarchy of .xlsx and .xlsm files and how to create custom ribbonUI. This should make it possible to access and modify the customUI ribbon via customXMLParts at runtime.

Opening and modifying excel files as zips: https://www.jkp-ads.com/articles/excel2007fileformat02.asp

VBA customUI editor: https://yoursumbuddy.com/ribbon-customui-xml-editor/