Disable Doubleclick
Thank you all for your answers. I tried them all and they
worked.
I used the following code from Patrick Molloy and it
disabled the doubleclick for the range of cells from A1
to A10.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As
Range, Cancel As Boolean)
Cancel = Not (Intersect(Target, Range("A1:A10")) Is
Nothing)
End Sub
Thanks a lot to all of you,
Brandon
-----Original Message-----
I am trying to disable the mouse doubleclick on certain
cells(range) of a spreadsheet. I know how to disable
doubleclicking for the entire spreadsheet using:
Application.EditDirectlyInCell = False
Is there a way apply this to a specific range only?
.
|