I don't think you can. And to me that makes pretty good sense.

Why would you want the user to select cells whose values they can't change? But
block them from selecting cells whose values they can change?



princejohnpaulfin wrote:

I am using Excel 2003.
I am attempting to protect only certain cells within an Excel worksheet. I
first click on FORMAT, CELLS, and "deselect" the "LOCKED" check box. I then
highlight the cells I wish to protect, repeat that step, only this time make
sure the LOCKED check box is checked.
I then go to to TOOLS, PROTECTION, PROTECT SHEET, and attempt to select the
option, and JUST the option for "Select locked cells", however, everytime I
select this option, a checkmark appears next to "Select unlocked cells" as
well. One seems to trigger the other. The net effect is that the WHOLE
worksheet becomes locked instead of just the protected cells.
Has anyone else experienced this problem and/or know of a solution?

Thankyou

--

Dave Peterson