arranging multiple custom menus

[BEEJAY]

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.

[Chip Pearson]

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, before:=4, temporary:=True)
Ctrl.Caption = "My Menu"

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"BEEJAY" <[email protected]> wrote in message
news:[email protected]...
> 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.

[BEEJAY]

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, before:=4, temporary:=True)
> Ctrl.Caption = "My Menu"
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "BEEJAY" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

[BEEJAY]

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, before:=4, temporary:=True)
> Ctrl.Caption = "My Menu"
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "BEEJAY" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>