Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

de-selecting locked cells in protection option

Status
Not open for further replies.

bayuga

Technical User
Jan 18, 2007
10
US
Hello,
I have this spreadsheet and i want to protect certain ranges of cells and the others I want to un protect. But everytine I go to Tools>protection and I uncheck the locked cells the unlocked cells gets uncheck as well. This only happens to a certain spreadsheet. I hope that I am clear. Ca anyone tell me why that is?
 
First, select the cells that you want the user to be able to change and Format > Cells. Go to Protection tab and uncheck Locked.

Next, Tools > Protection > Protect Sheet

Lilliabeth
-Why use a big word when a diminutive one will do?-
 
Thanks for your response Liliabeth but I think my problem is my computer problem. However, I would really like to thank you for your response to my original question. It worked. AWESOME!!!!

have a great day!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top