Hi Rick
Start here
http://support.microsoft.com/default...02&Product=xlw
How to customize menus and menu bars in Excel
http://support.microsoft.com/default...b;EN-US;213552
XL2000: List of ID Numbers for Built-In CommandBar Controls
http://support.microsoft.com/default...11&Product=xlw
XL2000: Sample Macros to Return ID for a CommandBar Control
http://support.microsoft.com/default...09&Product=xlw
XL2000: Sample Macros that Customize and Control Shortcut Menus
http://support.microsoft.com/default...50&Product=xlw
XL2000: Sample Macros for Customizing Menus and Submenus
http://support.microsoft.com/default...55&Product=xlw
XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items"
http://support.microsoft.com/default...66&Product=xlw
XL97: List of ID Numbers for Built-In Command Bar Controls
http://support.microsoft.com/default...14&Product=xlw
XL97: Sample Macros to Return ID for a CommandBar Control
http://support.microsoft.com/default...19&Product=xlw
XL97: Sample Macros for Customizing Menus and Submenus
http://support.microsoft.com/default...78&Product=xlw
XL97: Sample Macros That Customize and Control Shortcut Menus
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Rick Will" wrote in message ...
How do I go about creating custom menu items?
Thus far I have:
With Application.CommandBars(1).Controls.Add
(Type:=msoControlPopup)
.Caption = "Name"
.Visible = True
.Enabled = True
End With
This works fine. However I have no Idea of how to add
sub menus.