View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carsten[_2_] Carsten[_2_] is offline
external usenet poster
 
Posts: 3
Default Adding/Deleting from toolbars using VBA

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'
stick.

How can the above procedure be done using VBA code