Oops..The below is a wrong post.. To your question.......try the below..

Unprotect the sheet/ Unlock all cells/ Edit Goto Special Formula
Format Cells... Protection Locked..Protect the sheet

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Tools Options Spelling AutoCorrect Autocorrect and remove the
correction

If this post helps click Yes
---------------
Jacob Skaria


"Ra" wrote:

Please can you let me know if I can protect and hide several formulas in a
worksheet, yet allow the user to still input data and modify data once the
formulas have been protected?

Thank you