Unprotect the sheet. Next select all cells, then right-click, format cells,
click the protection tab and uncheck the box beside locked. Now highlight
what you do not want changed, right-click, format cells, protection tab, and
check the locked box. Now protect the sheet.
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"hannatrip" wrote:

I try to lock the cells with the formulas in them, i choose lock from cells
than go to the tools,protect sheet and lock it, now i can put any info at all
on the sheet, what am i doing wrong?? help please