Order of Drop-Down Menus
 

I have various menus that are added when Excel opens, as a result of coding
I've added in Personal.xla. How do I indicate what order I want these to be
in? I want them to start after Excel's 'HELP', and then be in a certain
order after that. Can someone advise how to do this?

Order of Drop-Down Menus
 

Hi
This will put a new control after Help

iHelpIndex = cbWSMenuBar.Controls("Help").Index
Set muCustom = cbWSMenuBar.Controls.Add(Type:=msoControlPopup,
after:=iHelpIndex)

you can use before instead of after too.
You can change "Help" to any other existing control as you add of
course.
regards
Paul

On Nov 13, 4:24*pm, Paige wrote:
I have various menus that are added when Excel opens, as a result of coding
I've added in Personal.xla. *How do I indicate what order I want these to be
in? *I want them to start after Excel's 'HELP', and then be in a certain
order after that. *Can someone advise how to do this? *

Order of Drop-Down Menus
 

Thanks, Paul!

" wrote:

Hi
This will put a new control after Help

iHelpIndex = cbWSMenuBar.Controls("Help").Index
Set muCustom = cbWSMenuBar.Controls.Add(Type:=msoControlPopup,
after:=iHelpIndex)

you can use before instead of after too.
You can change "Help" to any other existing control as you add of
course.
regards
Paul

On Nov 13, 4:24 pm, Paige wrote:
I have various menus that are added when Excel opens, as a result of coding
I've added in Personal.xla. How do I indicate what order I want these to be
in? I want them to start after Excel's 'HELP', and then be in a certain
order after that. Can someone advise how to do this?