Creating Custom Menus

R

Rick Will

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.
 
R

Ron de Bruin

Hi Rick

Start here

http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw
How to customize menus and menu bars in Excel http://support.microsoft.com/default.aspx?scid=kb;EN-US;213552
XL2000: List of ID Numbers for Built-In CommandBar Controls
http://support.microsoft.com/default.aspx?scid=kb;en-us;213211&Product=xlw
XL2000: Sample Macros to Return ID for a CommandBar Control
http://support.microsoft.com/default.aspx?scid=kb;en-us;213209&Product=xlw
XL2000: Sample Macros that Customize and Control Shortcut Menus
http://support.microsoft.com/default.aspx?scid=kb;en-us;213550&Product=xlw
XL2000: Sample Macros for Customizing Menus and Submenus

http://support.microsoft.com/default.aspx?scid=kb;en-us;166755&Product=xlw
XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items"
http://support.microsoft.com/default.aspx?scid=kb;en-us;159466&Product=xlw
XL97: List of ID Numbers for Built-In Command Bar Controls
http://support.microsoft.com/default.aspx?scid=kb;en-us;162814&Product=xlw
XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default.aspx?scid=kb;en-us;159619&Product=xlw
XL97: Sample Macros for Customizing Menus and Submenus http://support.microsoft.com/default.aspx?scid=kb;en-us;162878&Product=xlw
XL97: Sample Macros That Customize and Control Shortcut Menus
 
R

Ron de Bruin

Oops sorry
This is better

http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw
How to customize menus and menu bars in Excel


http://support.microsoft.com/default.aspx?scid=kb;EN-US;213552
XL2000: List of ID Numbers for Built-In CommandBar Controls

http://support.microsoft.com/default.aspx?scid=kb;en-us;213211&Product=xlw
XL2000: Sample Macros to Return ID for a CommandBar Control

http://support.microsoft.com/default.aspx?scid=kb;en-us;213209&Product=xlw
XL2000: Sample Macros that Customize and Control Shortcut Menus

http://support.microsoft.com/default.aspx?scid=kb;en-us;213550&Product=xlw
XL2000: Sample Macros for Customizing Menus and Submenus


http://support.microsoft.com/default.aspx?scid=kb;en-us;166755&Product=xlw
XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items"

http://support.microsoft.com/default.aspx?scid=kb;en-us;159466&Product=xlw
XL97: List of ID Numbers for Built-In Command Bar Controls

http://support.microsoft.com/default.aspx?scid=kb;en-us;162814&Product=xlw
XL97: Sample Macros to Return ID for a CommandBar Control

http://support.microsoft.com/default.aspx?scid=kb;en-us;159619&Product=xlw
XL97: Sample Macros for Customizing Menus and Submenus

http://support.microsoft.com/default.aspx?scid=kb;en-us;162878&Product=xlw
XL97: Sample Macros That Customize and Control Shortcut Menus
 
Top