By default cells are 'Locked' but are only protected when you protect the
worksheet as a whole.

If you want users to enter data into empty cells then 'Unlock' the cells
first then protect the sheet.



--

Regards,
Nigel




"John" wrote in message
...
How do you protect all the sheets in a workbook so the user can't enter
something in a cell that has a formula?

Thanks

JOhn