Protect/Lock Specific Cells
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? |
Put a password on the sheet protection:
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "srf1030" wrote in message ... 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? |
I don't want to protect the whole sheet, only certain cells. Is that possible?
"Anne Troy" wrote: Put a password on the sheet protection: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "srf1030" wrote in message ... 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? |
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 "srf1030" wrote in message ... I don't want to protect the whole sheet, only certain cells. Is that possible? "Anne Troy" wrote: Put a password on the sheet protection: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "srf1030" wrote in message ... 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? |
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??? "Anne Troy" wrote: 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 "srf1030" wrote in message ... I don't want to protect the whole sheet, only certain cells. Is that possible? "Anne Troy" wrote: Put a password on the sheet protection: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "srf1030" wrote in message ... 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? |
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. -- Sincerely, Michael Colvin "srf1030" wrote: 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??? "Anne Troy" wrote: 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 "srf1030" wrote in message ... I don't want to protect the whole sheet, only certain cells. Is that possible? "Anne Troy" wrote: Put a password on the sheet protection: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "srf1030" wrote in message ... 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? |
If you're using xl2002+, then you can use some of the protection options to
allow users to edit ranges on protected worksheets. srf1030 wrote: 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??? "Anne Troy" wrote: 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 "srf1030" wrote in message ... I don't want to protect the whole sheet, only certain cells. Is that possible? "Anne Troy" wrote: Put a password on the sheet protection: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "srf1030" wrote in message ... 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? -- Dave Peterson |
All times are GMT +1. The time now is 10:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com