Thread: Delete MenuItem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default Delete MenuItem

Off the top of my head I think you need "Chart..." instead of "Chart". Chart
brings up a wizard/form so it is "Chart..." (dot dot dot is Microsofts way of
saying that the button will bring up a form asking for more info) in the
menu.
--
HTH...

Jim Thomlinson


"Avi" wrote:

I try to delete the "Chart" subMenu item in the "Insert" menu item on the
main menu file of Excel with the following commands

Sub DeleteIt()
MenuBars(xlWorksheet).Menus("Insert").MenuItems("C hart").Delete
End Sub

But i get "Applicatin defined error message

The procedure works fine with other menu items.

Please help...

Avi

www.avibenita.com