Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add items to VBA-created menu?
I managed to created a custom menu. But I can't find the Add for the new
control to add items under the new menu. Help? Ed Sub AddNewMenu() Dim oCB As CommandBar Set oCB = Application.CommandBars("Worksheet Menu Bar") Dim newMenu As CommandBarControl Set newMenu = oCB.Controls.Add(Type:=10) newMenu.Caption = "MyMenu" newMenu.Enabled = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting the list items for ComboBox created using Forms | Excel Discussion (Misc queries) | |||
Add list to newly created menu | Excel Discussion (Misc queries) | |||
add list to newly created menu | Excel Worksheet Functions | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Menu item created w/ add-in removed due other add-in | Excel Programming |