| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display a custom menu item | Excel Programming | |||
| Delete specific menu item from custom menu | Excel Programming | |||
| Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
| Excel 2000 Custom Menu Item | Excel Discussion (Misc queries) | |||
| VBA-Make Custom Menu Item Fire | Excel Programming | |||
Linear Mode
