Thread: Selection Grid
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_6_] kirkm[_6_] is offline
external usenet poster
 
Posts: 156
Default Selection Grid



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