Pasting restricted data in cells with validation

I

Isito

I have a form where I use the data validation to restrict entering some of
the data. However even though the users cannot enter some of the data they
still can copy/paste anything from the different spreadsheets. The sheet is
password protected and they cannot change the formatting however when they
paste stuff from the other spreadsheets the formatting is also overriden.

Do you know if there is a way to only allow paste special - values and also
check the data when it is posted to the cells with validation.

Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top