John has a Webpage that offers an addin. The code is unprotected, so
you can see his methodology.
John Walkenbach : Create a Toolbar on the Fly
http://j-walk.com/ss/excel/tips/tip90.htm
HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
Hello, I want to save a custom command bar into an excel workbook.
Instead of doing that manually, I want to do with Vb code (before close,
join the command bar to the book, and delete the bar).
The Vb help says I can do it using the command bar property "context"
<Application.CommandBars("BarName").Context, but I do not know how to use
context (there is no example).
Does anyone know how to do it?
Thanks in advance