enable Right-click menu

[Saleh]

Hi

I have disable elements of the right click menu in the excel sheet and i
want to enable them (e.g. insert...., delete). What can i do to enable them
back?

 

[Ron de Bruin]

You can reset the whole cell menu
Application.CommandBars("Cell").Reset


Or Enable the items

Application.CommandBars("Cell").Controls("Delete...").Enabled = True

But better use the ID's
See
http://www.rondebruin.nl/menuid.htm

 

[Gord Dibben]

Change the VBA code that disabled them to re-enable them.


Gord Dibben MS Excel MVP