According to the OP the data validation isn't working, although my tests are otherwise. The workbook has VBA components, so I am asking if a contributor with VBA experience to see if there is perhaps a conflict with the code and data validation. I believe that you can get the gist of the issue if you start with post #10.
https://www.excelforum.com/excel-gen...ml#post4807697