enable Right-click menu
 

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?

enable Right-click menu
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Saleh" <Saleh @discussions.microsoft.com wrote in message ...
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?

enable Right-click menu
 

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


Gord Dibben MS Excel MVP

On Mon, 23 Jun 2008 13:42:03 -0700, Saleh <Saleh @discussions.microsoft.com
wrote:

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?