Mark,

You have to test the Target variable to determine if it is in the
range for which you want to disable double-click. For example,
the following code will disable double-click function in the
range A1:B10, and leave it to normal behavior in all other cells.

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"mark kubicki" wrote in message
...
in a beforeDoubleClick procedure, i set the cancel arguement to
true which
solves some wierd select/reselect problems that i was having;

however, when the user selects another cell, i want them to be
able to use a
double click to initiate in-cell editing; however the
beforeDoubleClick
procedure disabled it...

how (when the user selects a different cell that the double
click target) do
i get it back on?