View Full Version : [SOLVED:] Edit with VBA on Startup: File > Options > Customize Ribbon
Dschwarz
12-21-2023, 09:00 AM
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
12-21-2023, 09:30 AM
You will need to add ribbonX XML to the workbook. https://jkp-ads.com/articles/buildexceladdin.asp#The_user_interface
Dschwarz
12-22-2023, 01:36 PM
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.