I am doing some transcription work and I'm wanting to disable AutoComplete cell values for columns F & G. I have Excel 2007. I found the following code and changed "A" to F but I can't figure out how to disable column G as well. Surely there's a way to do this. I appreciate any help anyone can give me. Thanks in advance.
![]()
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
Bookmarks