A problem with user inputs is that they often copy-paste dates. I'd like
them to either type in a date or use paste-special-value. With multiple
users this is virtually impossible to control.

Is there a way to lock cell conditional formats but not restrict data entry?
--
GAM

hi, !

A problem with user inputs is that they often copy-paste dates.
I'd like them to either type in a date or use paste-special-value.
With multiple users this is virtually impossible to control.
Is there a way to lock cell conditional formats but not restrict data entry?

- using code is a valid alternate ?

- is there any chance that *copy* comes from a range of cells...
and any format-conditioned cell intersects [beyond] activecell in selection_change event ?

expecting your comments,
regards,
hector.