Prevent Autocomplete

[howard]

I would like to type for instance an "s" into a cell for eg A15, but when a type an "s" in select A15, for eg SVC is placed into cell A15. I want to prevent autocomplete from doing this on certain worksheets only

It would be appreciated if someone could kindly assist me

 

[Trevor G]

If you record a macro you can use that behind each worksheet. The Code would be something like this:

Application.EnableAutoComplete = False

 

[howard]

Thanks for the help