MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Protecting a cell or group of cells

Posted by Alonzo on June 29, 2001 11:52 AM

I was wondering if anyone could tell how I can Protect a cell or group of cells, so no one can get to them but myself. This would allow them to a us one cell or just a group of cells.


Posted by Connie on June 29, 2001 12:56 PM

You can protect your worksheet by going to Tools>Protection>Protect Sheet and then put in a password. If there are any cells you want to keep accessible to users, just select those cells, go to Format>Cells>choose Protection Tab and uncheck the "Locked" box. That way, the user can get to only those cells. If they try to change any other cells (which are locked) they will get a warning message that it is password protected.