Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding/Deleting from toolbars using VBA
what exactly do you want to do?
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding macros to toolbars | Excel Discussion (Misc queries) | |||
Adding and deleting rows with formulas ****Need Help**** | Excel Discussion (Misc queries) | |||
how to protect sheet from adding/deleting | Excel Discussion (Misc queries) | |||
Adding and deleting Range Names | Excel Programming | |||
Adding / Deleting from toolbars | Excel Programming |