Brandon,

Vasant's and Rob's answers are a lot less overkill.
Use what they gave you instead of what I gave you.

John

"John Wilson" wrote in message
...
Brandon,

Try this....Doubleclick disabled for range A1:B3 only
(modify to suit)

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Not Intersect(Target, Range("A1:B3")) Is Nothing Then
Application.EditDirectlyInCell = False
Cancel = True
Application.EditDirectlyInCell = True
End If
End Sub

John


"Brandon" wrote in 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?