How can one add submenus in Excel 2003?

H

Herwig

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
 
G

Gord Dibben

Herwig

The Menu Editor went out with Excel 95.

You can create Sub-Menus by dragging and dropping from
Tools>Customize>Commands>Macros "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.aspx?scid=kb;EN-US;830502

http://support.microsoft.com/support/kb/articles/Q159/6/19.asp

http://support.microsoft.com/support/kb/articles/Q162/8/78.asp

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q166755&


Gord Dibben Excel MVP
 
Top