Writing To A Locked Cell

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?

Hi dadrew

Here is a thread I Googled, my give you a start!

http://www.excelforum.com/excel-prog...-400-mean.html

Please Login or Register  to view this content.