Thanks again for your reply. Your time in trying to help is very much
First of all, I was using Excel 2003 at somebody else's computer. I do not
have Excel 2003 on my computer to test this all out.
However, I went to the MS website that you suggested. I have included a few
comments that I think might explain what is going on:
* By default the Select locked cells check box is selected. This check box
enables users to select cells with the Locked check box selected in the
Format Cells dialog box. When the Select locked cells check box is selected,
the Select unlocked cells check box is automatically selected.
* By default the Select unlocked cells check box is selected. This check
box enables users to select cells with the Locked check box cleared in the
Format Cells dialog box. When the Select unlocked cells check box is cleared,
the Select locked cells check box is automatically cleared. If there are no
unlocked cells on a protected sheet and this check box is not selected, users
cannot select any cells on the worksheet.
* Note: You cannot permit formatting of unlocked cells only.
Maybe you can test out the issue I am having (if you have a moment).
Unfortunately, this makes me kind of mad, because I'm not at a computer right
now that has Excel 2003 running, if I did, I would do this myself. However,
when I was at my friend's computer earlier this week, I'm pretty sure I
already did what I'm asking below. And...it did not work the way I wanted it
to. i.e., my friend wanted me to lock all but certain cells on a worksheet
that she was going to give to people to input numbers. My friend was not
happy, though, that the users of the worksheet could input numbers just fine
into unlocked cells, BUT...they also were able to change the formatting of
the cell (color, font, font size, borders, etc.), which she did not want them
to be able to do. We tried & tried & tried, we could not figure out a way to
do what she wanted.
Anyway, if you can try the following, you will see what I am talking about.
-Open Excel 2003
-Put your cursor in cell C3 & Highlight the block of cells C3 thru E5.
-Select Format/ Cells/ Unlock
-Select Tools/ Protection/ Protect Sheet
-Make sure the "Select locked cells" box is NOT checked
You will then see that all this does it that it does not allow you as the
user to get your cursor into any cells other than those that you previously
unlocked (i.e., the range of C3 thru E5) If your cursor is in cell E5 & you
hit the down arrow, your cursor will not move to cell E6, it will move to
cell C3. i.e., the user is not able to select any locked cells whatsoever
anywhere on the worksheet. The user will only be able to select cells that
have been previously unlocked.
If you are able to tell me the further steps at this point that I need to go
thru to allow users of this worksheet to be able to input numbers in to the
range of cells of C3 thru E5, but NOT be able to change any of the formatting
of these cells, please just pass along the additional steps that I need to
take to be able to do this.
I can call my friend and walk her thru the steps over the phone.
Again, your time in helping me out is greatly appreciated. If I can figure
this out, this will really be great, and will help us out a lot.