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

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 ?

Adding/Deleting from toolbars using VBA
 

what exactly do you want to do?

SV: Adding/Deleting from toolbars using VBA
 

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?