protect specific cell but allow edit on other cell

[Guest]

How can I protect specific cells but allow editing on other cells. Once the
cell is edited the file can be saved.

 

[Gord Dibben]

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

Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
and OK.

Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
and OK.

Now Tools>Protection>Protect Sheet. This is mandatory!!

You can set a password to unprotect. These can easily be broken in Excel but
will keep your formulas from being accidentally overwritten.


Gord Dibben Excel MVP

 

[Guest]

but by sheet protection the files could not be saved unless they know the
password. i want only specific cell to be locked preventing alteration but
still allow other cells to be edited and file save.

 

[Gord Dibben]

You can still save a workbook that has sheet protection enabled.

No need for anyone to know a password.

Did you try the method I posted or just reject it because you don't understand
the process?


Gord

 

[Guest]

i got it done. thanks. guess i was too rush

You can still save a workbook that has sheet protection enabled.

No need for anyone to know a password.

Did you try the method I posted or just reject it because you don't understand
the process?


Gord

 

[Gord Dibben]

Happy you got it sorted.

Gord

i got it done. thanks. guess i was too rush