Cable Forum - [Excel vba] Add and remove toolbar custom buttons

Cable Forum (https://www.cableforum.uk/board/index.php)

- General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)

- - [Excel vba] Add and remove toolbar custom buttons (https://www.cableforum.uk/board/showthread.php?t=33622897)

Ger	25-10-2007 09:24

[Excel vba] Add and remove toolbar custom buttons

Hi,
I have created a custom toolbar (in excel vba) with some buttons, but in the "Toolbar Options" menu
(on the toolbar) -> "Add or Remove Buttons" the voice relative to my toolbar is disabled, unlike to the others excel toolbars. I would add and remove my buttons selecting in this menu my toolbar and then check and uncheck the toolbar buttons.

Can you help me please?
Thanks in advanced
Ger
:confused:

TheNorm

25-10-2007 09:28

Re: [Excel vba] Add and remove toolbar custom buttons

Have you attached the toolbar to the workbook?

Quote:

Open the workbook to which you want to attach a toolbar.
On the Tools menu, click Customize, and then click the Toolbars tab.
Click Attach.
Click the custom toolbar you want to attach, and then click Copy. Note Be sure to save the workbook after attaching a toolbar.

Ger	25-10-2007 10:09

Re: [Excel vba] Add and remove toolbar custom buttons

Thanks but I have created a Custom Toolbar programmatically in vba.
I have an excel add-in with a toolbar. How can I programmatically attach my toolbar to the woorkbooks?
Anyhow I try on attach as you said but I can't add or remove toolbar buttons again.

All times are GMT +1. The time now is 01:21.