Hi,

I need to protect a worksheet with some cells still being able to input/amend data.

However, I need to control these unlocked cells to retain its formatting.
It should allows only updating of data into the cells.
Should the user copy and paste the data from other sources, these cells should still retain its formatting.

Could this be done without VB?

Many thanks in advance.


Regards,
CS