Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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?? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |