I have a sheet that runs code after updates occur on the sheet. One column
has a dropdown list. Depending on what's selected the next column also has a
dropdown list, but the values in the list change depending on the value
selected in the first list.

Normally it all works fine, but I have found that if the user starts to type
the value into the first list and the value has already been selected further
up the predictive text takes over. This would be OK but it would seam the
when this happens my code doesnt run.

Can I switch predictive text off for just one column?