Feb 28 2023 12:16 AM
I make large use of excel templates and data validation rules; the issue is to prevent users doing paste thus overriding the data validation rules. I used VBA to prevent this with partial success (i.e., MAC users etc.). Wouldn't be an idea to introduce a "disable paste" under the Protect sheet options menu?
Feb 28 2023 03:11 AM