Andrew
Toolbar and menu customization/settings created with your method 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
ToolsCustomizationToolbarsAttach.
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/de...l/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
On Sat, 02 Apr 2005 06:14:16 -0800, andrew fletcher
wrote:
Thx John,
Im not sure where the code exists for menu's. By menu's I just want to
clarify that I am talking about the custom menu's that can be added to
file|Edit|View|Insert etc etc... as opposed to toolbars. I appreciate
that toolbars can be turned on / off by accessing
view/toolbars/customise.
Im not too clued up on VB im afraid. I found 'this workbook' in the VB
editor which is a sub-menu of the VBA pproject. WHen clicked on it
brings up the properties.
Sorry for sounding a bit vacuous, suppose we all start smewhere. Could
you please try to expand on your explaination now that you have a feel
for my level of competence.
Thx - Andrew
*** Sent via Developersdex http://www.developersdex.com ***