Turning off autocomplete for one cell only
Thank you!
That was easy!
"Gary''s Student" wrote:
This is for cell B9, adjust to suite:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Range("B9"), Target) Is Nothing Then
Application.EnableAutoComplete = True
Else
Application.EnableAutoComplete = False
End If
End Sub
This is worksheet event code and goes in the worksheet code area, not a
standard module.
--
Gary''s Student - gsnu200764
"Brad" wrote:
I would like to turn off autocomplete for one cell only.
I understand that I can do this by having a blank line above and below the
cell and a blank column to the right and left of the cell. Is there any
another way??
|