Protecting Cells

P

Paul

I want to protect a few cells in a worksheet - not the whole worksheet. How
do I do it?
 
J

Jack Schitt

Sorry, you have to protect the whole worksheet, then UNprotect all of the
cells except those that you wish to secure. Alternative may be to provide
data validation on the cells that you wish to protect, but this is not
particularly secure (copy/paste will override, for example). For that
matter, nothing is secure, I guess.
 
F

Frank Kabel

Hi
first select the other cells, goto 'Format - Cells -
Protection' and unchek 'Locked'. After this protect the
sheet
 
Top