add-ins toolbar

S

shah

I have created add-ins and created new tool bar where I
put a macro. My problem is when I send that add-ins to my
friend and he adds that add-ins from tools menu. Than
toolbar, which I have created, is not come.

How can I send add-ins with toolbar when he adds add-ins
from tool menu toolbar will come automatically?

Thanks in advance.
Shah
 
G

Gord Dibben

shah

Were the buttons placed onto a Toolbar manually by dragging them there?

If so, the toolbar and menu customization/settings are saved in your *.XLB
file, which is on your computer and not accessible to others.

You could always export your *.xlb file to others, but this would destroy
their customizations.

You could also "attach" the Toolbar to the add-in via
Tools>Customization>Toolbars>Attach.

The best way to set up customizations is to create the buttons/toolbars/menus
through VBA so they appear when the workbook is opened and disappear when it
is closed.

Some instructions and code here.........

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno97ta/html/ofcmdbar.asp

Also John Walkenbach's downloadable MENUMAKR.XLS is a handy tool for
customizing menus.

Find it and sample code for creating "on the fly" toolbars.

http://www.j-walk.com/ss/excel/tips/commandbars.htm

Gord Dibben Excel MVP
 
Top