Thread: Sub menuing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Sub menuing

You want to do this in the same code that creates the SubItems or do you want
code to run when you select the created subitem?

--
Regards,
Tom Ogilvy


"Troubled User" wrote:

I have added a "NewMenuItem" to the main commandbar. Below that I have added
two SubMenuItems with no assigned OnAction events.

Set Item = CommandBars(1).Controls("NewMenuItem").Controls.Ad d
Item.Caption = "&SubItem1"
Item.BeginGroup = False

Set Item = CommandBars(1).Controls("NewMenuItem").Controls.Ad d
Item.Caption = "&SubItem2"
Item.BeginGroup = False

What I want to do is be able to select the "SubItem1" and create multiple
menu items below it.

Thanks.