Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to enable items on Excel draw menu bar. | Excel Discussion (Misc queries) | |||
how to enable right mouse click in the cell of excel 2007? | Setting up and Configuration of Excel | |||
How do i enable right click on excel? Mine doesn't work. | Excel Discussion (Misc queries) | |||
How do I enable the double-click drill down in Excel | Excel Discussion (Misc queries) | |||
Where is menu option to enable macros? | Excel Discussion (Misc queries) |