View Single Post
  #1   Report Post  
sam sam is offline
Junior Member
 
Posts: 2
Default disabling the copy paste function in a cell

Is there anyway to disable the copy/paste function in a cell in an excel spreadsheet but still be able to edit/type in the same cell?

For example, I want to set up a data entry spreadsheet where a user has to enter the same information twice (example - cell A1 and B1) to stop keying errors, there is a warning message in cell C1 that warns if cells A1 and B1 do not match but i do not want the user to simpily copy and paste the contents of A1 into B1, therefore negating the purpose ok the check column.

Any ideas would be a great help.

Thanks

Sam