Thread: How do I protect specific cells (like labels and formulas) on a w.
View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default
Evelyne

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

Hit CRTL + A(twice if xl2003) then FormatCellsProtection. Uncheck "locked"
and OK.

Select the cells you wish to lock and FormatCellsProtection. Check "locked"
and OK.

Now ToolsProtectionProtect Sheet. This is mandatory!!


Gord Dibben Excel MVP

On Thu, 31 Mar 2005 16:11:02 -0800, "Evelyne"
wrote:

I have a worksheet that has several cells that need to be protected (locked)
from changes. How do I lock only those cells without locking the whole
worksheet?

Reply With QuoteReply With Quote