View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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?