By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check "locked"
and OK.

Now ToolsProtectionProtect Sheet. This is mandatory!!

You can set a password to unprotect. These can easily be broken in Excel but
will keep your formulas from being accidentally overwritten.


Gord Dibben Excel MVP




On Wed, 14 Jun 2006 13:00:02 -0700, VegasBurger
wrote:

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!

Gord Dibben MS Excel MVP