Brandon,

In the Workbook code:

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target
As Range, Cancel As Boolean)
If Not Intersect(Target, Range("A1")) Is Nothing Then Cancel = True
End Sub

This is for doubleclick only, it doesn't prevent a user from editting
directly in the formula bar.

Rob


"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?