Excel ribbon

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


Public

Tested

Not My Work
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




Views 183 Downloads 73

VBA-Excel UI
ANmarAmdeen
810
Attachments
Revisions

v2.0