Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have been working with Steven Roman's, 'Writing Excel Macros with VBA' 2nd
Edition. The code below adds the Custom popup menu to the worksheet menu. The code does not contain a Temporary:=True statment when the control was added to the menu. Now I alway have a Custom popup menu when I launch Excel. Before I add the Temporary:=True to the Controls.Add line of code I want to delete the existing Custom menu. Can I get some help on how I can ID the current Custom menu item? No Tag was set and I don't know how to determine the controls ID so I can use it for the purpose of deleting it. Thanks in advance Hal Sub CreatePopup() ' Example 12-5 pg 149 Dim cbpop As CommandBarControl Dim cbctl As CommandBarControl Dim cbsub As CommandBarControl ' Create a popup control on the main menu bar Set cbpop = Application.CommandBars("Worksheet Menu Bar"). _ Controls.Add(Type:=msoControlPopup) cbpop.Caption = "&Custom" cbpop.Visible = True ' Add a menu item Set cbctl = cbpop.Controls.Add(Type:=msoControlButton) cbctl.Visible = True ' Next is required for caption cbctl.Style = msoButtonCaption cbctl.Caption = "MenuItem&1" ' Action to perform cbctl.OnAction = "ExampleMacro1" ' Add a popup for a submenu Set cbsub = cbpop.Controls.Add(Type:=msoControlPopup) cbsub.Visible = True cbsub.Caption = "&SubMenuItem1" ' Add a menu item to the submenu Set cbctl = cbsub.Controls.Add(Type:=msoControlButton) cbctl.Visible = True ' Next is required for caption cbctl.Style = msoButtonCaption cbctl.Caption = "SubMenuItem&2" ' Action to perform cbctl.OnAction = "ExampleMacro2" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Menu-Item and worksheet deletion questions | Excel Programming | |||
Menu Item name | Excel Programming | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
New menu bar item | Excel Programming |