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

  • Thread starter Paulo Costa \(Live\)
  • Start date
P

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
 
B

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
 
Top