C
Chris Watts
Can autocomplete be selectively turned off for some columns and left on for
others? [Excel 2007]
TIA
Chris
others? [Excel 2007]
TIA
Chris
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Umlas
Yes, using VBA code.
C
Chris Watts
Thanks Bob.
VBA hold no fears for me but some guidance as to the methods etc to achieve
thia.
Chris
VBA hold no fears for me but some guidance as to the methods etc to achieve
thia.
Chris
Bob Umlas said:Yes, using VBA code.
Chris Watts said:Can autocomplete be selectively turned off for some columns and left on
for others? [Excel 2007]
TIA
Chris
R
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
__________ Information from ESET Smart Security, version of virus signature database 4813 (20100128) __________
The message was checked by ESET Smart Security.
http://www.eset.com
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
Chris Watts said:Thanks Bob.
VBA hold no fears for me but some guidance as to the methods etc to
achieve thia.
Chris
Bob Umlas said:Yes, using VBA code.
Chris Watts said: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
C
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
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
Roger Govier said: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
Chris Watts said:Thanks Bob.
VBA hold no fears for me but some guidance as to the methods etc to
achieve thia.
Chris
Bob Umlas said: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