Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add menuitems to custom created menu
Hello,
I created a custom menu 'Extra's'. This menu is created with an Add In. But now I want to add new menu items to this menu. These menu items are created by another Add-In. But I can't mak it work. for example: Set NewControl = Application.CommandBars("Tools").Controls.Add(Type :=msoControlButton, ID:=1) works, but Set NewControl = Application.CommandBars("Extra's").Controls.Add(Ty pe:=msoControlButton, ID:= 1) does not work. And I need this to add new menu items. Or are there other ways to make this work? Thanks. René |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add menuitems to custom created menu
Hi Rene
Look here for example code http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Excel http://www.j-walk.com/ss/excel/tips/tip53.htm Creating Custom Menus (John Walkenbach) TIP http://www.erlandsendata.no/english/...oadcommandbars Ole P. Erlandsen's Web Site (Example workbooks) -- Regards Ron de Bruin http://www.rondebruin.nl "René" wrote in message ... Hello, I created a custom menu 'Extra's'. This menu is created with an Add In. But now I want to add new menu items to this menu. These menu items are created by another Add-In. But I can't mak it work. for example: Set NewControl = Application.CommandBars("Tools").Controls.Add(Type :=msoControlButton, ID:=1) works, but Set NewControl = Application.CommandBars("Extra's").Controls.Add(Ty pe:=msoControlButton, ID:= 1) does not work. And I need this to add new menu items. Or are there other ways to make this work? Thanks. René |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
Add list to newly created menu | Excel Discussion (Misc queries) | |||
add list to newly created menu | Excel Worksheet Functions | |||
Add items to VBA-created menu? | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming |