[SOLVED] capture right mouse button click event on cell

Hi,
how can i capture the right mouse button click event on a cell. I'd like to
enable/disable commands of the context menu in dependence to the selected
column.

TIA
Reinhard

Hi Reinhard,

Here is some event code to do it. Change th 9 to your column number.

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Column = 9 Then
Cancel = True
End If
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.





--
HTH

Bob Phillips

"Reinhard Thomann" <reinhardt@thomann.com> wrote in message
news:%2303K9Ru$EHA.3988@TK2MSFTNGP11.phx.gbl...
> Hi,
> how can i capture the right mouse button click event on a cell. I'd like
to
> enable/disable commands of the context menu in dependence to the selected
> column.
>
> TIA
> Reinhard
>
>