I am producing a survey in excel. I want to use drop down menus. I have protected the sheet in the normal way, but seem unable to prevent users copying the entry from the drop down list in column 1 and pasting the answer over the entries in column 2, which has a different validation list and drop-down menu.
I have been trying to use the error message, but that cannot stop a copy and paste. I have also tried to use conditional formatting, but to no avail.
Can anyone help please?
Thanks,
Jon
I have been trying to use the error message, but that cannot stop a copy and paste. I have also tried to use conditional formatting, but to no avail.
Can anyone help please?
Thanks,
Jon