By default, all cells are locked, so when you protect the
worksheet, no cell can be changed. You can select all the cells
with CTRL+A (more than once, depending on your Excel version).
Then change the Locked property to false by unchecking the Locked
box on the format cells dialog. This will unlock all cells. Then
press F5 to bring up the GOTO dialog, click Special and check the
Formulas box. This will select all cells with formulas. Now go
back to the Cell Formatting dialog and click the Locked and
Hidden properties.


"VegasBurger" wrote in
message
...
Ok, I am so close to this worksheet being done. Thank you
everyone for your
help and finally one last question, I hope :)

I have everything working the way I want it to work, now I want
to protect
my workbook from the people who might use it deleting the
funtions/formulas
from the cells. How can I do this and still allow them to use
the worksheets?

Thanks!