lock cell conditional format but not restrict data entry

G

GAM

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?
 
H

Héctor Miguel

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?
Click to expand...

- 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.
 
Top