View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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.