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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to prevent Cut&Paste to change style and data validation on protected sheet (https://www.excelbanter.com/excel-discussion-misc-queries/259535-how-prevent-cut-paste-change-style-data-validation-protected-sheet.html)

Paulo Costa \(Live\)

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

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

Stefi

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

Maybe you should use PasteSpecial/Values instead of Paste.
--
Regards!
Stefi

€žPaulo Costa (Live)€ ezt Ã*rta:

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

All times are GMT +1. The time now is 07:32 PM.