How to prevent Cut&Paste to change style and data validation on pr
Did you try going to 'Tools' choose 'Options' then choose the 'Edit' tab?
then unclick what you don't want anyone to be able to do on your spreadsheet.
Hope this helps
"Paulo Costa (Live)" wrote:
Hi
I would like to prevent that pasting to unlocked cells on a protected sheet
changes the data validation and style. Is this possible?
Thanks,
PC
|