Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I currently running the following code to create a Custom Menu:
Sub AddNewMenu() Dim HelpIndex As Integer Dim NewMenu As CommandBarPopup ' Get Index of Help menu HelpIndex = CommandBars(1).Controls("Help").Index ' Create the control Set NewMenu = CommandBars(1) _ .Controls.Add(Type:=msoControlPopup, _ Befo=HelpIndex, Temporary:=True) ' Add a caption NewMenu.Caption = "&Michigan154" End Sub Sub Allen() Dim Item As CommandBarControl Set Item = CommandBars(1).Controls("Michigan154") _ .Controls.Add Item.Caption = "&Allen Park" Item.OnAction = "AllenPark_154" End Sub How can I add some submenus to this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2000 Custom Menu Item | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
VBA-Make Custom Menu Item Fire | Excel Programming | |||
Setting OnAction of custom menu item? | Excel Programming | |||
Custom Menu Item specific to a workbook | Excel Programming |