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.