I've had to use Format Cells - Protection and select LOCK or UNLOCK to
define which cells are locked when the worksheet is protected (using TOOLS -
Protection)

"Screen/Display size" wrote:

How do you prevent users overtyping cells?? I have created a form in Excel
2003 for users to fill in. The form has enbedded formula. I have trie
dplaying around with LOCK and PROTECT to stop users mistakenly overtyping the
formulae and headings........ but without success.

Can You help??