ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protect/Lock Specific Cells (https://www.excelbanter.com/excel-discussion-misc-queries/34006-protect-lock-specific-cells.html)

srf1030 July 6th 05 03:04 PM

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?

Anne Troy July 6th 05 03:10 PM

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?



srf1030 July 6th 05 03:35 PM

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?




Anne Troy July 6th 05 03:41 PM

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?






srf1030 July 6th 05 07:17 PM

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?







Michael July 6th 05 07:58 PM

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?







Dave Peterson July 6th 05 08:05 PM

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 12:56 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com