problem data validation and copy/paste

[Theo]

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?

 

[Praburam]

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?

Hi,

While protecting the worksheet or workbook you will be provided with
the another option called "Allow users to edit range":

With that you can specify those areas which you want to allow to copy
or paste.. Other cells will be protected.

Try this keep the password different for protection and allowing edit
range..

Thanks and Regards,

S. Praburam

 

[Theo]

That won't work, since users will need to be able to paste into all cells.
What about
allowing users to enter/paste data into worksheet 1
and then
running a macro that will copy a row from worksheet 2 (which is protected)
and copy ONLY the data validation edits into all rows in worksheet 1.
I'm not familiar with macros - I did find a sample that would work EXCEPT it
was pasting values and I want it to paste validation edits.