Hi, I have exhausted looking for a solution on YouTube and other google searches and in desperate need of help.
I have a file where I created a data validation drop-down list in column A in my spreadsheet. I want my users to HAVE to select from the drop-down list and NOT be able to override it with a new supplier name by doing a copy and paste or CTL-C and CTL-V. I have tried a couple of options, but nothing seems to work the way I want it to. I have locked, unlocked, protected & unprotected, but nothing seems to work. I am open to having a macro in the file, but I am a novice and not really sure how to write one. I am running Win 10, if that matters at all.
Any help is greatly appreciated!
I have a file where I created a data validation drop-down list in column A in my spreadsheet. I want my users to HAVE to select from the drop-down list and NOT be able to override it with a new supplier name by doing a copy and paste or CTL-C and CTL-V. I have tried a couple of options, but nothing seems to work the way I want it to. I have locked, unlocked, protected & unprotected, but nothing seems to work. I am open to having a macro in the file, but I am a novice and not really sure how to write one. I am running Win 10, if that matters at all.
Any help is greatly appreciated!