Enabling menu items

M

mika.

I want to ensure that I enable everything back to normal
when I leave a program. The problem is that I think in
the Edit menu, depending on what is selected, either
the "Delete" or "Delete..." menu item is listed under the
Edit menu, resulting in an "Invalid procedure call or
argument" for this: Application.CommandBars
("Worksheet Menu Bar").Controls("Edit").Controls
("Delete").Enabled = True if Delete is not currently
shown on the menu.

Any ideas how I could ensure that "Delete"
and "Delete..." are enabled at appropriate times for the
next time the user opens Excel?

Thanks.
 
Top