ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro for right click (https://www.excelbanter.com/excel-programming/445367-macro-right-click.html)

kalpesh

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

Don Guillett[_2_]

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


All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com