Custom Menus in designated file

H

Hans

Hi,

Is it possible to have a custom menu designated to 1 file or to certain
designated files? I do not need all my custom menus in all my files. I see
now that when I make a custom menu it is available in all files I open.

Thanks,

Hans
 
F

Frank Stone

hi
It is to my understanding that custom menus are user
machine specific and not file specific. menus are not
attached to a file but to the application on the machine
that created the custom menu.
 
G

Gord Dibben

Hans

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