share a workbook but protect the formulas

C

clemrogan

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

Bill Kuunders

Protect the sheet

Use- Tools > Protection > Protect Sheet, you can enter a password
This will protect all cells in the worksheet, as all the cells are formatted
to be locked.

To select all the non-formula cells use <edit><go to><special><select
constants.
then Format > Cells > Protection Tab and uncheck the locked selection.
 
D

Dave Peterson

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.
 
Top