share a workbook but protect the formulas
 

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

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.


--
Greetings from New Zealand
Bill K
"clemrogan" wrote in message
...
I need to share workbooks but protect all the formulas while still allowing
our clients to enter data.

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