How to remove an Excel Main Menu item inserted by .xla file

D

Dennis

Excel 2003 & 97

Thought I knew how to do this. But ...

An .xla file placed a new item on the Main Menu (along with File, Edit,
........ Help, Misc) Let us call it "Misc".

I removed the Misc.xla file from Addins folder and forced Excel to ask me to
remove it from the Addins list.

But the Misc is still on the Main Menu bar.

How do I get rid of it?

TIA Dennis
 
P

Peo Sjoblom

Try this, do view>toolbars>customize, grab the offending menu and drag it
from any menu toolbar (I usually drag it to the sheet)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
D

Dennis

Got it!

Sub DeleteMenuBarItem()
Application.CommandBars("Worksheet Menu Bar").Controls("Misc").Delete

End Sub


Thanks
 
D

Dennis

I tried that Frank and it did not work.

Thanks for taking your time!!

Dennis

****************************************
 
D

Dennis

Peo,

Your solution is what I learned a year ago, but unfortunately forgot about
it because I had not
used it recently!

Thanks Dennis

********************************
 
Top