View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Accidental Delete of Menu Item Helllllp!

Wes,

Go to the View menu, choose Toolbars, then Customize. There,
select "Worksheet Menu Bar" and choose Reset.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Wes Jester" wrote in message
...
While trying to learn more about VBA, I coded
Application.CommandBars(1)..Controls("Insert").Del ete

Well, it did exactly what I asked and now I have no "Insert"

menu item.
Even closing and re-opening XL without macros does not help.

Of course, right after this I relaized I should use

Enable=False, etc., but
the horse had already left the barn.

Does anybody have a solution other than re-installing EXCEL

Thanks

Wes