Thread: Locking cells
View Single Post
 
Old 07-13-2017, 09:39 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by melvin1942 View Post
I am wanting to lock a cell. I asked for help and got an answer, I followed the direction that I got, but when I try to lock a cell it seems as though it did not work. I can still change what is in the cell. Do you have to protect the whole sheet for it to work?Melvin1942
Yes, you have to protect the sheet.

Quote:
Originally Posted by melvin1942 View Post
If I protect the sheet does this keep a person from entering anything in unprotected cells?
No user can change cells with Locked checked. Any user can change cells with Locked unchecked.

Quote:
Originally Posted by melvin1942 View Post
Can I lock a cell by itself?Melvin1942
Reply With Quote