how do i lock a cell with a fromula?
 

how do i lock a cell with a fromula?
 

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

CTRL + a(twice in 2003) to select all cells.

FormatCellsProtection. Uncheck "locked" and OK

Now select the sections/rows/cells to protect and FormatCellsProtection.
Check "locked" and OK

ToolsProtectionProtect Sheet

The section/row locking does not work if you don't protect the sheet.


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 12:47:02 -0700, Elin wrote:


Gord Dibben MS Excel MVP