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?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top