Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
arranging multiple custom menus
How does excel determine which menu item is first, which is last, and how the
inbetweens are arranged. I now have 5 custom menus (4 made with JWalks Menumaker). All my custom menus are just to the left of "Help". However, if possible, I need to group these menus, by the way they are used together ( 1 group of 3, 1 group of 2). Is this possible? How? I'm positive I have read something about this a long time ago, but can't find a thing now. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
arranging multiple custom menus
Specify the Before argument when you create the menu item.
Dim Ctrl As CommandBarControl Set Ctrl = Application.CommandBars("Worksheet Menu Bar").Controls.Add( _ Type:=msoControlPopup, befo=4, temporary:=True) Ctrl.Caption = "My Menu" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "BEEJAY" wrote in message ... How does excel determine which menu item is first, which is last, and how the inbetweens are arranged. I now have 5 custom menus (4 made with JWalks Menumaker). All my custom menus are just to the left of "Help". However, if possible, I need to group these menus, by the way they are used together ( 1 group of 3, 1 group of 2). Is this possible? How? I'm positive I have read something about this a long time ago, but can't find a thing now. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
arranging multiple custom menus
Chip: I changed ONE of the codes to the # 4. when I exited and reopened Excel,
It was in the fourth Menu Item on the list. Aha! Now I've got it. I changed the respective codes to # 10, # 11, # 12 and # 13. Close Excel, Open Excel # 10 is in # 9 Position # 11 is in # 11 # 12 is in # 14 # 13 is in # 13 Help is not on the end anymore - Its in # 12 position. Obviously I'm missing something. I did more web searches and checked my "bibles", but can't find a thing about how this is supposed to work.l Would you be so kind as to advise? or direct me? Thank-you "Chip Pearson" wrote: Specify the Before argument when you create the menu item. Dim Ctrl As CommandBarControl Set Ctrl = Application.CommandBars("Worksheet Menu Bar").Controls.Add( _ Type:=msoControlPopup, befo=4, temporary:=True) Ctrl.Caption = "My Menu" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "BEEJAY" wrote in message ... How does excel determine which menu item is first, which is last, and how the inbetweens are arranged. I now have 5 custom menus (4 made with JWalks Menumaker). All my custom menus are just to the left of "Help". However, if possible, I need to group these menus, by the way they are used together ( 1 group of 3, 1 group of 2). Is this possible? How? I'm positive I have read something about this a long time ago, but can't find a thing now. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom FaceID's for Custom Menus | Excel Programming | |||
Custom menus | Excel Programming | |||
Custom faces for custom menus/commandbars | Excel Programming | |||
Custom menus | Excel Programming | |||
Custom Menus | Excel Programming |