Dear Linds:

This one's pretty easy.

All the cells on your worksheet are locked by default. The quickest way to
fix your problem is to unlock all of them. Then lock the three you want and
protect the worksheet.

Select all the cells.
-- There's a box between column a and row 1. Clicking on this will
select all the cells in the workbook.

Now Unlock them
-- Go to Format on the menu and select CELLS then PROTECTION
-- UNCHECK the LOCKED radio button

Select the three cells that you want to protect go through the same steps
"Format--Cells--Protection--CHECK the LOCKED button.

Now all you need to do is protect the worksheet.

TOOLS--Protection--PROTECT SHEET

This is going to bring up a dialog box that you'll need to read before
selecting ok.

HINT: Keep your passwords simple and only 4 characters if possible. The
reason for this is in case you forget them you can recover the password with
the trial version of password recovery software. Your password is only going
to be a deterrant. Don't think that it's going to make it secure so don't
use your pin # or anything like that.

At work we use "beep" as our default. Each user has control to improve the
sheet because they know the password but having it protected keeps them from
accidentaly messing it up.

GOOD LUCK!!!



"Linds" wrote:

I have 3 cells on a form that I need to be locked, so no one can change the
value in it. But the other boxes can be typed in. How can I lock those 3
cells only?