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 !
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 !