Autocomplete - on/off by column

[Chris Watts]

Can autocomplete be selectively turned off for some columns and left on for
others? [Excel 2007]
TIA
Chris

 

[Bob Umlas]

Yes, using VBA code.

 

[Chris Watts]

Thanks Bob.
VBA hold no fears for me but some guidance as to the methods etc to achieve
thia.
Chris

Yes, using VBA code.

Can autocomplete be selectively turned off for some columns and left on
for others? [Excel 2007]
TIA
Chris

 

[Roger Govier]

Hi Chris

For example to turn it off for column C

Columns("C:C").Application.EnableAutoComplete = False

Setting the attribute to True will re-enable it.
--
Regards
Roger Govier

Thanks Bob.
VBA hold no fears for me but some guidance as to the methods etc to
achieve thia.
Chris

Yes, using VBA code.

Can autocomplete be selectively turned off for some columns and left on
for others? [Excel 2007]
TIA
Chris

__________ Information from ESET Smart Security, version of virus
signature database 4813 (20100128) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4813 (20100128) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Chris Watts]

Hi Roger,
Tried that but it disables autocomplete for all columns not just column C.

What I did get to work was a Worksheet level procedure:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Target.Column
' Disable for column A - change to suit
Case 1
Application.EnableAutoComplete = False
Case Else
Application.EnableAutoComplete = True
End Select
End Sub

cheers
Chris

Hi Chris

For example to turn it off for column C

Columns("C:C").Application.EnableAutoComplete = False

Setting the attribute to True will re-enable it.
--
Regards
Roger Govier

Thanks Bob.
VBA hold no fears for me but some guidance as to the methods etc to
achieve thia.
Chris

Yes, using VBA code.

Can autocomplete be selectively turned off for some columns and left on
for others? [Excel 2007]
TIA
Chris

__________ Information from ESET Smart Security, version of virus
signature database 4813 (20100128) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus
signature database 4813 (20100128) __________

The message was checked by ESET Smart Security.

http://www.eset.com