Good afternoon.
I have a spreadsheet that I use to validate the length of characters in a barcode label.
The user needs to scan the barcode and then by using data validation it tests whether the correct no of characters are present in the barcode. If not an error message pops up saying the barcode is incorrect.
I wish to prevent the user from entering (typing) anything in the cell manually.
I need to be certain that data is only able to be entered by scanning the barcode. Otherwise they will add or delete characters to bypass the error.
Is this possible ?
Bookmarks