R
Raja
I have a file which has Data Validation as list so that the users can only
select from the list for the sake of data integrity.
Some people are copying and pasting the data which replaces the data
validation. I protected the sheet but that doesn't allow me to select any of
the list items. So I unlocked the cells that have data validation. Then
Protected my sheet. That doesn't replace the data validation but it still
allows the user to over write the exisiting entry.
What I really want is that Once the data validation has been set and the
sheet has been protected then I don't want anyone to copy and paste the data
on the cells that contain the data validation.
Some help will be appreciated!!
Kindest Regards
Rajeev Rawat
select from the list for the sake of data integrity.
Some people are copying and pasting the data which replaces the data
validation. I protected the sheet but that doesn't allow me to select any of
the list items. So I unlocked the cells that have data validation. Then
Protected my sheet. That doesn't replace the data validation but it still
allows the user to over write the exisiting entry.
What I really want is that Once the data validation has been set and the
sheet has been protected then I don't want anyone to copy and paste the data
on the cells that contain the data validation.
Some help will be appreciated!!
Kindest Regards
Rajeev Rawat