lock cell conditional format but not restrict data entry
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.
|