Commandbars

[Joanne]

Hello,
We have a menu item that we want to remove but it keeps changing its
position on the file dropdown. It's a third party add in. We want to keep
the program but access the executable from a toolbar icon instead of the
menu. How do we remove this menu item by name rather than by its position in
the file drop down, since its position keeps changing?

Thanks for any help you can provide.

 

[Jonathan West]

Hello,
We have a menu item that we want to remove but it keeps changing its
position on the file dropdown. It's a third party add in. We want to
keep
the program but access the executable from a toolbar icon instead of the
menu. How do we remove this menu item by name rather than by its position
in
the file drop down, since its position keeps changing?

Thanks for any help you can provide.

Hi Joanne,

Basically the only sure way is to get in touch with the vendor of the add-in
and ask them to provide you with a version without the menu.

Failing that, you could cycle through the CommandBars.ActiveMenuBar.Controls
collection. When you find the control that has the caption of the
misbehaving addin, set the control's Visible property to False.

Without knowing what the add-in does to display the menu, there is no way to
be sure that the menu won't reappear, but this will give you a reasonable
chance.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org