Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Custom Menus
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Custom Menus
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Custom Menus
Oops sorry
This is better 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 "Ron de Bruin" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Drop-down menus with subset drop-down menus | Excel Worksheet Functions | |||
Please Help Me with Custom menus | Excel Worksheet Functions | |||
custom menus | Excel Programming | |||
Custom menus | Excel Programming | |||
Custom Menus | Excel Programming |