View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com.nospam is offline
external usenet poster
 
Posts: 172
Default save command bar into an excel workbook using vb

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