You can select which cells to lock and then enable worksheet protection.

By default all cells on a sheet are locked when sheet protection is enabled.

Hit CRTL + A(twice for 2003 users) to select all cells.

FormatCellsProtection. Uncheck "locked" and OK out.

Now select those formula cells and FormatCellsProtection. Check "locked".
Ok out.

Now ToolsProtectionProtect Sheet.

Tip: ToolsCustomizeCommandsFormat. Scroll down to the Padlock(lock cells)
icon.

Drag to your Toolbar.

Saves a few steps when selecting cells to be locked/unlocked.

Gord Dibben Excel MVP


On Wed, 08 Dec 2004 00:59:42 GMT, "Tdinova" wrote:

I am using formulas to get averages , standard deviation and other
figurers... I want to be able to lock the cell so others cannot change my
formula but be able to change certain values to get averages and other
information ....


I was trying to use the protection under tools to no hope...


any help would be appreciated