PDA

View Full Version : Worksheet_BeforeDoubleClick is not invoked



gonen
06-04-2012, 04:43 AM
Hi

I added :

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target(1, 1).Address = "$L$9" Then
MsgBox "AAAA"
Cancel = True
End If
End Sub

I expected to see the Msgbox when dbl click on L9 but nothing happens.

I did ^g + ?application.EnableEvents

I get - True

Macros are enabled (I have them running)


Any idea ???


Thanks !

Bob Phillips
06-04-2012, 08:10 AM
Works for me. Did you put in in a/the right worksheet code module?

gonen
06-04-2012, 09:05 AM
MY MISTAKe

SORRY - I put it in the wrong place....


Thanks !