|
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. |
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. |
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. |
| All times are GMT +1. The time now is 12:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com