Herwig
The Menu Editor went out with Excel 95.
You can create Sub-Menus by dragging and dropping from
ToolsCustomizeCommandsMacros "Custom Menu Item".
Alternative is to create the sub menus on the fly with VBA code when the
workbook opens.
The sites below give example code and tips.
Note: some sites say for XL97, but same for 2003
http://support.microsoft.com/default...b;EN-US;830502
http://support.microsoft.com/support.../Q159/6/19.asp
http://support.microsoft.com/support.../Q162/8/78.asp
http://support.microsoft.com/default...EN-US;Q166755&
Gord Dibben Excel MVP
On Thu, 2 Dec 2004 10:27:06 -0800, Herwig
wrote:
In previous versions of Excel there was a menu editor which allowed to add
submenus to a menu. Is this not possible in Excell 2003?
All the help flies I consulted were completely useless!!
Many thanks for help
Herwig