Adding/Deleting from toolbars using VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
Rob Bovey wrote in message of 05-11-2003 (see thread: "How can
Click to expand...
I get into VBA for costum toolbar ?"):
"In order to modify an attached toolbar you first need to
Click to expand...
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
 
I have a userdefined toolbar (attached to an Excel project) in which one of the buttons are activating an invalid ("wrong") vba macro.
I want to "unattach" the toolbar from the project - let the button point to another vba macro - reattach the toolbar to the project - and save the project with this "new" toolbar.
Can this be done in VBA ?

----- greg prost skrev: -----

what exactly do you want to do?
 
Back
Top