Block typing in cell but allow pasting

[kwackcraig]

Hi All,

I have a sheet that is used for reconciling information from 2 sources.

This includes a column that I only want filled with a pasted value, as one user insists on typing the amount in manually and invariably ends up making some errors.

Is there a way I can lock these cells so they cannot type but can paste?

Thanks in advance.


Craig

 

[sandy666]

maybe DataValidation - Custom: =""