Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub-Menu Listings
Is it possible to create sub-menu lists in Xcel? For example, when you click
on the "Start" menu, you can then click on "Programs", then "Office", then "Xcel". I am trying to create something similar. Thanks for any input. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub-Menu Listings
Yes, possible.
See John Walkenbach's MenuMaker site with a downloadable sample workbook. http://www.j-walk.com/ss/excel/tips/tip53.htm Gord Dibben MS Excel MVP On Fri, 26 Oct 2007 17:05:00 -0700, thall600 wrote: Is it possible to create sub-menu lists in Xcel? For example, when you click on the "Start" menu, you can then click on "Programs", then "Office", then "Xcel". I am trying to create something similar. Thanks for any input. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub-Menu Listings
This should get you going
Sub MultiLevelMenus() Dim oCb As CommandBar Dim oCtl1 As CommandBarPopup Dim oCtl2 As CommandBarPopup Dim oCtl3 As CommandBarPopup Dim oCtlBtn As CommandBarButton Set oCb = Application.CommandBars("Worksheet Menu Bar") With oCb Set oCtl1 = .Controls("Tools").Controls.Add( _ Type:=msoControlPopup, _ temporary:=True) oCtl1.Caption = "Level1" With oCtl1 Set oCtlBtn = .Controls.Add( _ Type:=msoControlButton) oCtlBtn.Caption = "Level1 Button1" oCtlBtn.FaceId = 161 oCtlBtn.OnAction = "myLevel1Button1Macro" With oCtl1 Set oCtl2 = .Controls.Add( _ Type:=msoControlPopup) oCtl2.Caption = "Level2" With oCtl2 Set oCtlBtn = .Controls.Add( _ Type:=msoControlButton) oCtlBtn.Caption = "Level2 Button1" oCtlBtn.FaceId = 161 oCtlBtn.OnAction = "myLevel2Button1Macro" Set oCtl3 = .Controls.Add( _ Type:=msoControlPopup) oCtl3.Caption = "Level3" With oCtl3 Set oCtlBtn = .Controls.Add( _ Type:=msoControlButton) oCtlBtn.Caption = "Level3 Button1" oCtlBtn.FaceId = 161 oCtlBtn.OnAction = "myLevel3Button1Macro" End With End With End With 'etc. End With End With End Sub -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "thall600" wrote in message ... Is it possible to create sub-menu lists in Xcel? For example, when you click on the "Start" menu, you can then click on "Programs", then "Office", then "Xcel". I am trying to create something similar. Thanks for any input. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
name listings | Excel Discussion (Misc queries) | |||
Multiple listings | Excel Discussion (Misc queries) | |||
Excel Search Listings | Excel Worksheet Functions | |||
Creating automatic listings | Excel Discussion (Misc queries) | |||
IF statments for multiple listings. | Excel Worksheet Functions |