I've created my own menu which utilizes menu items from the existing Worksheet menu bar in Excel.

ie CommandBars("Worksheet Menu Bar").FindControl(ID:=30007).Copy

I need to hide some submenu items listed under the menu item. So I do this:

CommandBars("MyMenuBar").Controls(1).Controls(1).V isible = False

My question is this -- I only need one of the submenu items to be visible, so is there an easier way to do this rather than hide each individual item? Can I hide all the submenu items with a vba statement and then just make the one item I need visible?

Thanks.