I have a code like this

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Target.Offset(0, 1) = Target

End Sub

in spite of cancel=true statement when I right click the target, the submenu
comes up and so the event code does not work. where is the mistake.

the cancel=true shouldn't be necessary but you will need to put in the SHEET
module instead of a regular module or ThisWorkbook module

--
Don Guillett
SalesAid Software

"R..VENKATARAMAN" wrote in message
...
I have a code like this

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Target.Offset(0, 1) = Target

End Sub

in spite of cancel=true statement when I right click the target, the
submenu comes up and so the event code does not work. where is the
mistake.

Is the code behind the correct worksheet?

Have you disabled events and not re-enabled them?



"R..VENKATARAMAN" wrote:

I have a code like this

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Target.Offset(0, 1) = Target

End Sub

in spite of cancel=true statement when I right click the target, the submenu
comes up and so the event code does not work. where is the mistake.

--

Dave Peterson

If the OP doesn't want to see the Cell menu after rightclicking, won't he need
that "cancel = true" line?

Don Guillett wrote:

the cancel=true shouldn't be necessary but you will need to put in the SHEET
module instead of a regular module or ThisWorkbook module

--
Don Guillett
SalesAid Software

"R..VENKATARAMAN" wrote in message
...
I have a code like this

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Target.Offset(0, 1) = Target

End Sub

in spite of cancel=true statement when I right click the target, the
submenu comes up and so the event code does not work. where is the
mistake.




--

Dave Peterson

Yeah. my bad

--
Don Guillett
SalesAid Software

"Dave Peterson" wrote in message
...
If the OP doesn't want to see the Cell menu after rightclicking, won't he
need
that "cancel = true" line?

Don Guillett wrote:

the cancel=true shouldn't be necessary but you will need to put in the
SHEET
module instead of a regular module or ThisWorkbook module

--
Don Guillett
SalesAid Software

"R..VENKATARAMAN" wrote in message
...
I have a code like this

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Target.Offset(0, 1) = Target

End Sub

in spite of cancel=true statement when I right click the target, the
submenu comes up and so the event code does not work. where is the
mistake.




--

Dave Peterson

thanks all of you. I checked again in a new workook the macro is ok.
previous time also I placed the macro only in the worksheet event
module nolt in the standard module.. But the excel sheet was sent by
somebody. I dont know whether he/she has done some enableevents .
anyhow it is ok in my sheet. thank you once again all of you. the doubt
is cleared.
venkat


Don Guillett wrote:
Yeah. my bad

--
Don Guillett
SalesAid Software

"Dave Peterson" wrote in message
...
If the OP doesn't want to see the Cell menu after rightclicking, won't he
need
that "cancel = true" line?

Don Guillett wrote:

the cancel=true shouldn't be necessary but you will need to put in the
SHEET
module instead of a regular module or ThisWorkbook module

--
Don Guillett
SalesAid Software

"R..VENKATARAMAN" wrote in message
...
I have a code like this

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Target.Offset(0, 1) = Target

End Sub

in spite of cancel=true statement when I right click the target, the
submenu comes up and so the event code does not work. where is the
mistake.




--

Dave Peterson