prevent overtyping cells

[Screen/Display size]

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??

[swatsp0p]

First, UNLOCK only the cells you want the user to enter data, all other cells should be locked.

Next, choose Tools>Protection>Protect Sheet

on the Protect Sheet dialog box, UNCHECK the Select Locked Cells option (enter a password if desired) and click OK.

Users will now be able to only access unlocked cells, thus protecting all of your formular and informational cells.

Good luck

Bruce

[Barb R.]

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??