View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LRodgers
 
Posts: n/a
Default Data Validation Protection

I have created a form using data validation drop-downs for most of my input
fields and then protected the spreadsheet allowing edits to selected fields.
The problem I have is that you can copy & paste values on top of the
drop-downs without getting an error.

Is there a way to ensure that a user ONLY selects from a list in a drop-down
while still allowing a cell or 2 to be available for free text?

Thank you.