View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GAM GAM is offline
external usenet poster
 
Posts: 1
Default lock cell conditional format but not restrict data entry

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