Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default macro for right click

Hello,

i nee a macro to restrict right click option.
eg, in sheet 1 do not allow right click option

please help me
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,522
Default macro for right click

On Feb 12, 11:23*am, kalpesh
wrote:
Hello,

*i nee a macro *to *restrict right click option.
*eg, *in sheet 1 do not allow right click option

*please help me

right click sheet tabview codeinsert this

Private Sub Worksheet_BeforeRightClick( ByVal Target As Range, Cancel
As Boolean)
Cancel = True
End Sub
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
Add macro to right click Steven Excel Programming 1 October 31st 08 03:17 AM
How to run a macro upon a cell click Banzai Excel Programming 3 July 26th 07 09:19 PM
Is this possible? Click a cell to run a macro John Smith Excel Programming 2 November 23rd 06 03:37 PM
Can I add a Macro to right-click Menu? Ed Excel Discussion (Misc queries) 8 October 11th 06 02:43 PM
Macro to Click Button? [email protected][_2_] Excel Programming 4 July 15th 06 12:03 AM


All times are GMT +1. The time now is 08:37 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"