Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 6th 05, 03:04 PM
srf1030
 
Posts: n/a
Default 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   Report Post  
Old July 6th 05, 03:10 PM
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Old July 6th 05, 03:35 PM
srf1030
 
Posts: n/a
Default

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   Report Post  
Old July 6th 05, 03:41 PM
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Old July 6th 05, 07:17 PM
srf1030
 
Posts: n/a
Default

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   Report Post  
Old July 6th 05, 07:58 PM
Michael
 
Posts: n/a
Default

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   Report Post  
Old July 6th 05, 08:05 PM
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
requires that merged cells must be identically sized? Catt Excel Discussion (Misc queries) 11 July 3rd 05 12:36 PM
Blocking specific cells Triangle Excel Worksheet Functions 1 June 29th 05 10:26 AM
Showing zero in specific cells Swingbridge. Excel Discussion (Misc queries) 2 February 12th 05 05:56 AM
print specific cells Wendy Excel Discussion (Misc queries) 1 February 10th 05 07:52 PM
Protecting specific cells in a worksheet. GaryS Excel Worksheet Functions 2 January 6th 05 05:47 PM


All times are GMT +1. The time now is 03:36 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017