prevent overtyping cells
 

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

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

Next, choose ToolsProtectionProtect 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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=384536

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