Once the following code has been executed -

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
Dim sAddr As String
sAddr = "A1:P84"
If Not Intersect(Target, Range(sAddr)) Is Nothing Then
Cancel = True
frmConfig.Show
End If
End Sub

.... the cell that was double clicked remains selected, with a black
grid showing.

Can this be turned off - by code?

Thanks - Kirk

The short answer is no. However, it can be moved to another cell. There
must be an active cell on the active sheet, so there is going to be a cell
with a black "grid" somewhere on the sheet. You can pick a cell to move it
to and simply use:

ChoiceCell.Active

With ChoiceCell being replaced with the actual cell reference.

"kirkm" wrote:



Once the following code has been executed -

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
Dim sAddr As String
sAddr = "A1:P84"
If Not Intersect(Target, Range(sAddr)) Is Nothing Then
Cancel = True
frmConfig.Show
End If
End Sub

.... the cell that was double clicked remains selected, with a black
grid showing.

Can this be turned off - by code?

Thanks - Kirk

On Sat, 24 Feb 2007 07:03:08 -0800, JLGWhiz
wrote:

The short answer is no. However, it can be moved to another cell. There
must be an active cell on the active sheet, so there is going to be a cell
with a black "grid" somewhere on the sheet. You can pick a cell to move it
to and simply use:

ChoiceCell.Active

With ChoiceCell being replaced with the actual cell reference.

That sounds like it'll do nicely. Can you give me a example of usage,
please?

I tried "A1".Active and variations thereof without getting the right
syntax. And no help from F1.

Thanks - Kirk