Hi MedTech,

By default, every Excel cell is protected. However, you must go to Tools on
the menu bar, and click the menu option "Protect Sheet". On the Protect
Sheet window, check the options that you want and type in a password
(Password is optional). Then click OK. That will protect the sheet.

If you just want to protect certain cells in a sheet, right-click on the
cell(s) that you do not want to protect. Then click on the menu option
"Format Cells". On the Format Cells window, click on the tab "Protection".
Uncheck the box "Locked" under the Protection tab. That will unprotect the
cell(s) that you want. Then follow the steps above to protect those cells
that you want.

I hope it helps.

"MedTech" wrote:

hopefully I stopped my first posting, if not I am sorry.
We use a formatted worksheet for a couple of our tests values. We use the
same formatted worksheets daily, and just save them under a new name. We have
had a few techs change the quality control values and some of the conditional
formatting, that should not have access to this (causes a lot of correction
for us). I would like to password protect just those certain cells and allow
access only for myself and my supervisor to prevent this. How can one
password protect just certain cells and allow other cells to have information
imputted into them. We are using Excel 2003