Excel - protection

[ckelly0172]

hi....
Is it possible to protect a range of cells rather than the whole book or sheet.
Thanks
Craig

 

[gizmo1973]

Yes it is
Select the range you want to protect then go to format and protection, tick the protect box and then lock the worksheet (it won't have any effect unless you lock)
Ensure that the other cells i.e. not your range are unprotected though

Regards, Phil.

M.U.F.C. Show your true support here:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts

 

[ckelly0172]

Superb.... works a treat.
Cheers Gizmo
Craig
LUFC forever....

 

[DPlank]

Is it me or was that last note added to the sig inflammatory??



Dave

"Probably the only Test Analyst on Tek-Tips"

Take a look at Forum1393 & sign up if you'd like

 

[xlbo]

not really, considering LUFC's current position !!

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[gizmo1973]

Ah but mine is permanent (bit like my team I suppose)

Regards, Phil.

M.U.F.C. Show your true support here:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts