Help to change position in the menubar

[lex_m]

I am using John Walkenbach code to create a menubar, it works fine, right now it puts it before the 10th button, but is there anyway to change the position of the menu bar so it is the last thing on the bar no matter how many buttons are there, if I put a number like 15 it errors out. Thanks

  Set MenuObject = Application.CommandBars(1). _
                    Controls.Add(Type:=msoControlPopup, _
                    before:=10, _
                    temporary:=True)

 

[Jon von der Heyden]

What happens if you completely omit the before argument? If memory serves it adds it to the end, but I'm on 2010 here...

 

[lex_m]

Jon, that did it.
Thanks