View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Custom menu problems

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 ***