You can lock (or unlock) cells via Format|cells|protection tab

On that tab, check the Hidden box to hide the formula--but you need to protect
the worksheet to take effect (tools|Protection|protect sheet)

Be aware that worksheet protection is pretty darn simple to break.

clemrogan wrote:

I need to share workbooks but protect all the formulas while still allowing
our clients to enter data.

--

Dave Peterson