Accidental Delete of Menu Item Helllllp!

[Wes Jester]

While trying to learn more about VBA, I coded
Application.CommandBars(1)..Controls("Insert").Delete

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

 

[Chip Pearson]

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 [email protected]