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 […]
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/