View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Adding/Deleting from toolbars using VBA

Carsten,

As far as I know, you can't change (attach or delete) toolbars
contained in workbooks with VBA.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Carsten" wrote in message
...
Rob Bovey wrote in message of 05-11-2003 (see thread: "How can

I get into VBA for costum toolbar ?"):
"In order to modify an attached toolbar you first need to

remove it from the workbook by selecting it and clicking the
Delete button. The toolbar will still be available in Excel. Make
your modifications to it and then reattach it to the workbook by
going back into the Attach Toolbars dialog, selecting the toolbar
from the left-hand listbox and clicking the Copy button to add it
to the workbook. Click OK until your out of all the dialogs and
be sure to save the workbook or the changes won't
stick."

How can the above procedure be done using VBA code ?