MrExcel Publishing
Your One Stop for Excel Tips & Solutions

protecting a single cell


Posted by Lisa on August 02, 2001 11:34 AM

Is it possible to protect just one cell in a worksheet?
Is so, how?

Thanks!


Posted by Barrie Davidson on August 02, 2001 11:38 AM

Set the protection properties for all the cells to "Unlocked" and then set your one cell to "Lock". To select the entire worksheet, click on the grey box to the left of the letter A in the columns and above the number 1 in the rows.

Hope this makes sense to you.
Barrie

Posted by Lisa on August 02, 2001 12:05 PM


Okay, I hate to look stupid, but I don't get it. I tried the unlock/lock
and the message I got is that the worksheet has
to be protected first. I protect it and it won't
let me unlock/lock. What's going on?

thanks again!

Posted by lenze on August 02, 2001 12:57 PM

I believe you will find the message says the locking will not take affect until you protect the sheet. So, when the sheet is unprotected, set the cell(s) lock/unlock property, then protect the sheet.

Posted by Al Hardy on August 04, 2001 9:08 AM