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 edit/error
message) and the data validation is replaced unless they paste with values
only.
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.
So here is what I am tyring to do:
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?