[Q] Protecting a formating against Copy Paste
 

Hi everyone

I have a tricky problem. I need to protect the formating of a
spreadsheet against the copy paste, but on the other side I want to
allow the user to paste values. I find two possible solutions, but I am
not sure they are feasable

First solution, having a VBA code that "forces" a copy paste by value
when the user is only pasting normally. Is that kind of code doable in
Excel?

Second solution, protecting the spreadsheet partially, such that the
user can still past things in the sheet but can not affect the
conditional formating. I also need the user to be able to insert or
delete rows.

If you see a way to do that in Excel or VBA, I would be really
interested!

Thanks in advance
Charles