Hi - I created a customized ribbon, how do I write code so that it gets added on workbook open and deleted on workbook close, just like the Add-ins menu? thanks.
Fortunately, that's a very straightforward question, so the answer has been addressed countless times in this forum. At the bottom of this page, you will see five threads that the system has identified as being similar to your own. Failing that Ron De Bruin has an excellent site and guide on how to add code for your own custom ribbon - he even has a page with multiple examples (with code) for you to adapt (link)
I did a search on the site and didn't see anything, and the 5 posts below don't really answer the question. I went to the site you mentioned, and they want me to download software, which I can't do.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.