Adding a button/toolbar to an Add-in

[Cage]

This is probably very easy but I cannot seem to add a button/toolbar to an add-in. I have written code for an addin and would like to add a button in order to run the macro, so that I can then email the addin and it will install on someone elses machine.

Any ideas?

TIA Cage

 

[TonyJollans]

Hi Cage,

To create a toolbar you Add to the CommandBars Collection.
To create a toolbar button you Add to the Controls Collection of a Toolbar.

You would normally put the code for this in the Workbook_Open Event, possibly with corresponding code to remove the toolbar in the Workbook_BeforeClose Event.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[apeoortje]

It's available in the FAQs for this forum,

http://www.tek-tips.com/faqs.cfm?fid=5255"