View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MFTiger MFTiger is offline
external usenet poster
 
Posts: 2
Default Data Validation - Do not want to allow pasting into the cell

How can a cell with a data validation drop down box not allow users to paste
into the cell. When they paste, it allows values not in the drop-down list.
However the user cannot free-type into the cell anything not in the drop-down
list.