How to prevent Cut&Paste to change style and data validation on protected sheet

[Paulo Costa \(Live\)]

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

 

[Barb H]

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\)]

Thanks Barb, but this doens't sort out the issue.