ExcelBanter - Add custom menu item after Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Add custom menu item after Help (https://www.excelbanter.com/excel-programming/433698-add-custom-menu-item-after-help.html)

Christine

Add custom menu item after Help

I have code that adds a menu item before Help, but I would like it to be
after so it is more visible. The code line I have now is

MenuBars(xlWorksheet).Menus.Add Caption:=SortMenuName, befo="Help"

I tried changing "before" to "after" but it didn't work.

Thank you in advance for your replies.

Chris

Patrick Molloy[_2_]

Add custom menu item after Help

MenuBars(xlWorksheet).Menus.Add Caption:=SortMenuName

"Christine" wrote:

I have code that adds a menu item before Help, but I would like it to be
after so it is more visible. The code line I have now is

MenuBars(xlWorksheet).Menus.Add Caption:=SortMenuName, befo="Help"

I tried changing "before" to "after" but it didn't work.

Thank you in advance for your replies.

Chris

Christine

Add custom menu item after Help

Fantastic! Thank you, Patrick.

"Patrick Molloy" wrote:

MenuBars(xlWorksheet).Menus.Add Caption:=SortMenuName

"Christine" wrote:

I have code that adds a menu item before Help, but I would like it to be
after so it is more visible. The code line I have now is

MenuBars(xlWorksheet).Menus.Add Caption:=SortMenuName, befo="Help"

I tried changing "before" to "after" but it didn't work.

Thank you in advance for your replies.

Chris

All times are GMT +1. The time now is 05:36 PM.