Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to enable items on Excel draw menu bar. JD Excel Discussion (Misc queries) 3 May 10th 08 01:51 AM
how to enable right mouse click in the cell of excel 2007? Francis Setting up and Configuration of Excel 0 August 29th 07 10:42 AM
How do i enable right click on excel? Mine doesn't work. Right Click Excel Excel Discussion (Misc queries) 1 April 19th 07 07:46 PM
How do I enable the double-click drill down in Excel MFINE Excel Discussion (Misc queries) 4 May 15th 06 07:37 PM
Where is menu option to enable macros? dc1995 Excel Discussion (Misc queries) 1 January 19th 06 08:01 PM


All times are GMT +1. The time now is 01:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"