View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb H Barb H is offline
external usenet poster
 
Posts: 3
Default 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