You can protect the content of cells from being changed and/or hide the formulas of cells from being viewed.
Conditions for protecting cells
- The cell must be locked (in the Format Cells dialog box, Protection tab).
- The sheet must be protected.
Conditions for hiding text/formula in the Formula bar
- The cell must be hidden (in the Format Cells dialog box, Protection tab).
- The sheet must be protected.