I have 7 worksheets within my workbook. A number of cells on sheets 2-7 are filled in by the data that is on sheet 1 via some VBA. I want to be able to lock those cells on sheet 2-7 to prevent the user from changing the data there (it should only be changed on sheet 1) If I lock the worksheets 2-7 then a 400 error is produced, I belive this is because I am trying to write to a locked cell. Is there a way around this please?