Add ribbon menu to certain macro-based workbook to run macro, will only be available in that workbook. To any xlsb or xlsm manually (not using RibbonXEditor)
List of available icons https://bert-toolkit.com/imagemso-list.html
Helpful links ...
https://github.com/OfficeDev/office-custom-ui-editor
https://docs.microsoft.com/en-us/archive/msdn-magazine/2007/june/advanced-basics-using-ribbonx-from-visual-basic
https://github.com/fernandreu/office-ribbonx-editor
https://medium.com/codex/how-to-build-a-custom-ribbon-in-excel-a3bc531551e1
https://bert-toolkit.com/imagemso-list.html
Add ribbon menu to certain macro-based workbook to run macro, will only be available in that workbook. To any xlsb or xlsm manually (not using RibbonXEditor)
> Rename extension from xlsb or xlsm to zip
> Extract this new zip to a folder ...
> Add folder /customUI
> Add file customUI.xml inside it
Use xml block (attached) to insert 1 command and 1 separator after it
> Modify /_rels/_rels file to have additional line to refer to this customUI.xml [attached example]
> Zip them again
> Rename extension zip to xlsb or xlsm as used in original
> Open in Excel
> Rename extension from xlsb or xlsm to zip
> Extract this new zip to a folder ...
> Add folder /customUI
> Add file customUI.xml inside it
Use xml block (attached) to insert 1 command and 1 separator after it
> Modify /_rels/_rels file to have additional line to refer to this customUI.xml [attached example]
> Zip them again
> Rename extension zip to xlsb or xlsm as used in original
> Open in Excel
Views 332
Downloads 222
CodeID
DB ID