how do I protect a single cell from being change in excell
 

how ca I protect a single cell on a workbook

how do I protect a single cell from being change in excell
 

Select all cells and FormatCellsProtection.

Clear the "Locked" option and OK

Select a single cell and enable the "locked" on that cell.

Now ToolsProtectionProtect sheet.


Gord Dibben MS Excel MVP

On Wed, 17 Oct 2007 17:51:00 -0700,
wrote:

how ca I protect a single cell on a workbook