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?

Hi

select the whole worksheet (or the bits you want people to get to) then
choose format / cells / protection and untick locked ... now if you unlocked
all cells, you'ld need to lock the ones that you don't want them to get to.

once you've locked and unlocked the appropriate cells, choose tools /
protection / protect sheet.

Cheers
JulieD

"Evelyne" wrote in message
...
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?

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?