I want the worksheet to be protected, primarily to prevent users from
disabling validation. But, I also want users to be able to copy/paste data
which negates the validation process (ie., they don't get the error message).
If I could enable formula auditing (specifically 'circle invalid data') AND
protect the worksheet then the user could see what they copied/pasted that
was in error.
Requirements:
Users must be able to copy and paste
Don't want users to be able to change the data validation edits OR
delete/insert columns
That's it. Any advice?