protect cell

[lak]

how to protect only a cell?should the work sheet also be protected fo
protecting a cell

 

[Frank Kabel]

Hi
- first select all cells which should be unprotected
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now protect the worksheet

 

[lak]

hi

Thanks for the quick reply,however i wanted to know if i can protec
only a particular cell so that no changes can be made to that cel
alone & i should be able to work in other cells.

For example:

if A1 contains "Name",nobody should be able to change the spelling o
"Name" or access this cell alone(i.e A1),but can work on the rest o
the cells..can u pls help me out


Thanks
La

 

[Dave Peterson]

You can unlock all the cells on the worksheet, then come back and lock that one
cell.

And then you need to protect the worksheet.

Locked cells go hand in glove with protected worksheets.

That said, worksheet protection is very weak. There's code posted here every
day/week that would unprotect the worksheet.