View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mbp mbp is offline
external usenet poster
 
Posts: 2
Default Preventing copy/paste on validated cells

Hi
I've got a column of cells with validation.
If a user instead of typing values into the cells, copy/paste from another
cell, the origial validation settings are overwritten.
Is there any way to prevent the user to do this, otherwise validation is not
worth much.