prevent overtyping cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I protect cells or a range of cells in excel spreadsheet? 1
Conditional Formatting when Overtyyping a Function 4
cell-formula does not calcualte 1
Prevent Cell modification when Excel is executed 2
Preventing user input for individual cells 3
cell protection 2
Conditional Formatting Against a Formula - not it's result 3
Sum Time - strange result (site & cpearson researched) 4

Back
Top