Accidental Delete of Menu Item Helllllp!
 

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

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