I have a spreadsheet that has lots of data validation - all different types - lists, numbers, dates etc.
I am aware that pasting into these cells will remove the data validation. I can't just prevent users from pasting though as pasting data is a vital part of the spreadsheet's functionality.
The only thing I can think of is to prevent users from using the normal paste function - and only allow "paste values". Is anyone able to advise how to achieve this?
I am aware that pasting into these cells will remove the data validation. I can't just prevent users from pasting though as pasting data is a vital part of the spreadsheet's functionality.
The only thing I can think of is to prevent users from using the normal paste function - and only allow "paste values". Is anyone able to advise how to achieve this?