+ Reply to Thread
Results 1 to 2 of 2

Add menuitems to custom created menu

  1. #1
    René
    Guest

    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(Type:=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. #2
    Ron de Bruin
    Guest

    Re: 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é" <[email protected]> wrote in message news:[email protected]...
    > 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(Type:=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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1