speary

By default when a work sheet is protected all cells are locked.

Select cells in which users are to enter data.

FormatCellsProtection. Uncheck the "locked" option.

Now ToolsProtectionProtect Sheet.

Set the options you wish users to have then provide a password and OK.

Note: sheet passwords are easily cracked but the locking method will protect
the formulas from inadvertent erasure or change.


Gord Dibben Excel MVP

On Thu, 21 Jul 2005 09:59:37 -0500, speary
wrote:


Is there a way I can lock my formulas so no one can change them when i
send my spreadsheet out? I have about 50 cells with formulas in them in
4 or 5 columns and I need them all locked. Thank you for any
suggestions.