Edit with VBA on Startup: File > Options > Customize Ribbon

[Dschwarz]

I am looking for a way to automatically uncheck/hide individual ribbon menu headings upon opening a workbook using vba. Any suggestions would be appreciated.

[Jan Karel Pieterse]

You will need to add ribbonX XML to the workbook. https://jkp-ads.com/articles/buildexceladdin.asp#The_user_interface

[Dschwarz]

Thank you for the reference to ribbonX. Much appreciated!


You will need to add ribbonX XML to the workbook. https://jkp-ads.com/articles/buildexceladdin.asp#The_user_interface