Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Sub Menu Item to Current Custom Menu Renato Excel Programming 2 December 19th 05 12:48 AM
Add list to newly created menu Anthony Excel Discussion (Misc queries) 4 February 25th 05 01:53 AM
add list to newly created menu Anthony Excel Worksheet Functions 1 February 25th 05 12:57 AM
Add items to VBA-created menu? Ed Excel Programming 1 January 19th 05 11:15 PM
Custom Menu return to Excel Menu upon Closing VetcalcReport Excel Programming 2 August 2nd 04 02:59 PM


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"