How can one add submenus in Excel 2003?
 

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

Hi Herwig

Help Flies can be like that on bad days <bg
See if http://www.erlandsendata.no/english/index.php?t=envbacb is of any
relevance.

HTH. Best wishes Harald

"Herwig" skrev i melding
...
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

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