View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default How do I prevent someone copying information into a cell in excel

right click on the cell, Format Cells / Protection / Locked
then- Tools / Protection / Protect sheet and give it a password

"Frank" wrote:

I am reciving #REF errors from a calculation when a user of the excel sheet
copies and paste information over from a website...