locking formulas

select the whole sheet or used range
then from format cells--protection

unlock all the cells ,
exit
now
select those with formulas
format cells-protection
set to locked and hidden
exit
then protect the sheet,

Here is a doc I had created for another user.. Hope this helps

Find attached. Attachment 170471

review tab