Thread: how do I protect a single cell from being change in excell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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

Reply With QuoteReply With Quote