protect cell

  • Thread starter Thread starter lak
  • Start date Start date
Hi
- first select all cells which should be unprotected
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- now protect the worksheet
 
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
 
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.
 
Back
Top