Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
new custom menu
Hello,
In office 2003; If I create a new toolbar. And I have a new menu item on this toolbar. Can I programatically add or remove items on this menu item? how can you do that? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
new custom menu
You can,
Code to add a new Menu Item Sub MenuCreate() Dim mnMenu As Object Set mnMenu = CommandBars("Worksheet Menu Bar").Controls.Add(Type:=msoControlPopup, befo=5, temporary:=True) mnMenu.Caption = "Example" With mnMenu With .Controls 'the code below adds a button With .Add(msoControlButton) .Style = msoButtonIcon .FaceId = 463 .Caption = "About" .OnAction = "About" End With End With End With End Sub Any problems then let me know "greg" wrote in message ... Hello, In office 2003; If I create a new toolbar. And I have a new menu item on this toolbar. Can I programatically add or remove items on this menu item? how can you do that? thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
new custom menu
thanks
"DMc2007" wrote in message ... You can, Code to add a new Menu Item Sub MenuCreate() Dim mnMenu As Object Set mnMenu = CommandBars("Worksheet Menu Bar").Controls.Add(Type:=msoControlPopup, befo=5, temporary:=True) mnMenu.Caption = "Example" With mnMenu With .Controls 'the code below adds a button With .Add(msoControlButton) .Style = msoButtonIcon .FaceId = 463 .Caption = "About" .OnAction = "About" End With End With End With End Sub Any problems then let me know "greg" wrote in message ... Hello, In office 2003; If I create a new toolbar. And I have a new menu item on this toolbar. Can I programatically add or remove items on this menu item? how can you do that? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Context menu (Right click menu) not working in sheet changeevent. | Excel Programming | |||
Displaying A custom menu as a popup menu | Excel Programming | |||
Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
VBA - Disappearing custom menu and custom toolbar | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming |