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