| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? |
|
#6
|
|||
|
|||
|
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? |
|
#7
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Blocking specific cells | Excel Worksheet Functions | |||
| Showing zero in specific cells | Excel Discussion (Misc queries) | |||
| print specific cells | Excel Discussion (Misc queries) | |||
| Protecting specific cells in a worksheet. | Excel Worksheet Functions | |||
Linear Mode
