Protect/Lock Specific Cells

[Guest]

I would like to be able to protect or lock certain cells of a worksheet. I
only want our directors to be able to access these cells. How do I do that?

 

[Anne Troy]

Put a password on the sheet protection:
http://www.officearticles.com/excel/cell_locking_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

I would like to be able to protect or lock certain cells of a worksheet. I
only want our directors to be able to access these cells. How do I do

that?

 

[Guest]

I don't want to protect the whole sheet, only certain cells. Is that possible?

 

[Anne Troy]

Please read the article. If you lock a cell, it becomes locked WHEN you
protect the sheet. If you don't lock a cell, it does NOT become locked EVEN
IF YOU protect the sheet.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Guest]

It doesn't look like it's possible to do what I'm looking for. I want other
users to be able to utilize the sheet, but not be able to change these two
cells, so I don't want to protect the whole thing. I only want certain
people to change those two cells by using a password. Thoughts???

 

[Guest]

Select all the cells except the ones you want protected, then go to format -
protection and unlock the cells. Then, go to tools - protection and protect
the work sheet. That will protect only the two cells you want.

 

[Dave Peterson]

If you're using xl2002+, then you can use some of the protection options to
allow users to edit ranges on protected worksheets.