Cell Protection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

college1 - 05 Oct 2004 14:29 GMT

Arite. Does anybody Know if its posible to protect an individual cell
The only options i get are to "protect sheet", "protect workbood" o
"protect and share workbook". Im needing a bit of help. Cheers

Reply to this Message

Frank Kabel - 05 Oct 2004 14:36 GMT

Hi
- first select all cell you DON'T want to protect
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- Now protect the sheet ('Tools - Protect - Protect sheet')

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Arite. Does anybody Know if its posible to protect an individual

cell.

> The only options i get are to "protect sheet", "protect workbood" or
> "protect and share workbook". Im needing a bit of help. Cheers.
[quoted text clipped - 4 lines]
> college1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15026
> View this thread: http://www.excelforum.com/showthread.php?threadid=266425

Reply to this Message

firefytr - 05 Oct 2004 16:31 GMT

To add to what Frank has said, if you ar using Excel 2002 (XP) o
greater, you have much more options are your fingertips than i
previous versions. When you do as described above by Frank, after yo
hit Protect Sheet, a box will pop up and allow you to select what you
user's are able to do to the sheet or not. You can make it so the
cannot select locked cells, not insert/delete rows, not use autofilter
etc; very handy feature

--
firefyt

Reply to this Message