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
 
S

Stefi

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



„Paulo Costa (Live)†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do you restrict the users from copying and pasting 1
Protected sheet - attempt to delete row = unmerged cells 5
Protect Data validation cells from copy paste 3
Cell Fromat Protection 4
VBA code and protected cells 9
Prevent paste from re-formatting cell 4
Protect validation but allow drop down selection 1
Auto fit text in cell of a protected worksheet 3

Top