beforeDoubleClick (target, true)

[mark kubicki]

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?

 

[Chip Pearson]

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]

if the target cell is later selected by click (not a doubleclick), will the
user then be able to double click within the active cell to edit the
contents (i would want them to be able to)?