I have a very complicated tool that I developed that produces a mass amount of information. Technically, the whole sheet should be a database drive website. However, it is a spreadsheet:
The entire tab is protected against modification with the exception of Cell B1-E1 (Merged). This cell uses data validation from the tab "Families!A:A". My problem appears to be that non-english speaking people are playing the game and using some other source for their selection and pasting it into the field. When they paste, it overwrites the formatting and data validation for that field and breaks the sheet.
At least twice a day I have to reset the format for that cell. Is there a way to protect the cell so that they may only select from the drop down?