Dave and Sue,
I understand about picking the range I want to sort. But the users of the
information I supply use the A-Z, Z-A, and Sort functions. They can sort
using any of the 8 columns of information. And are not spreadsheet savvy to
grab just the data and not the header. And I trust the users less than I
trust Excel keeping the integrity of the data.
Does this protection funtion work at face value that is written in the help
screen?

"Dave Peterson" wrote:

My _guess_ is that excel is just guessing that you wanted the contiguous range
(including row 1) sorted when you only selected L2.

Personally, I don't like excel to guess--so I select the range to sort. And I'm
still afraid of those A-Z and Z-A icons. (Yeah, I know that xl2002 added the
warning about expanding the range to include adjacent columns, but I'm chicken.)



Sue wrote:

Hi Dave,
I have tried again with the same result. I did:
I did select all first and unlocked all cells.
Then highlighted cells B1:Y1 and locked only those cells (header row)
Toolsprotectionallow users to edit ranges
Using collapse box typed in B2:Y366 (also previously did it by highlighting
B2:Y366 before going to protectionallow users to edit ranges)
No password
Apply
Protect sheet
Checked boxes are select unlocked cells and sort in the lower portion of
window otherwise all are unchecked. Left the top box of "Protect the
worksheet and contents of locked cells" checked. So in total I have three
boxes on the protect sheet window checked.
Ok
(All columns are unhidden at the beginning of all this process)
Then I click on cell L2, click on A-Z key button and it comes up with "This
cell or chart ... is read only." It says the same thing if I go to DataSort
or click the Z-A button.
Is there something somewhere else that I need to go to first or last to tell
it allow sort even though protected. It seems like the sort box checked in
the protection box is not working. But it works okay if I don't lock my
header row. The stages above are exactly what I am doing. As I have done
each stage I have typed it on to this page to you to make sure.

"Dave Peterson" wrote:

I couldn't duplicate your problem.

But I selected the range (B2:y366). How did you select the range to sort? Did
you select the whole column(s)?

If you did, then that's the problem.

(I also unchecked the "select locked cells" on the worksheet protection
dialog--so I couldn't even select those header cells.)



Sue wrote:

Dave,
I have just tried the above steps without locking the header row cells and
it protects and sorts fine so I suppose that is better than nothing. Is that
the only choice I have for this scenario or is there a way to lock my
headings row (which is only 1 row) and protect and sort?

"Dave Peterson" wrote:

I tried this and it worked ok for me.

Can you try one more time?

Sue wrote:

Excel 2003 worksheet
I have data in B1 being the header row through to Y366.
I have selected all cells and unlocked them. I have then selected B1:Y1 and
locked them as they are my header row.
I then went tools,protection,allow users to edit and input a range of
B2:Y366. did not want to give password permission, clicked apply and then
clicked protect sheet and checked unlocked cells and sort and then OK.
When I then go to sort data it tells me "The cell or chart you are trying to
change is protected and therefore read-only."
To modify a protected cell or chart, first remove protection using the
Unprotect the sheet command (Tools menu, Protection submenu) You may be
prompted for a password.
What am I doing wrong. Should it not sort even though the protection is on
if I have a user range input?
Someone please help.
I did have columns hidden but they have all be displayed prior to the first
step as above.
I want it protected as I have formula's that will be tucked away on my
hidden columns that I don't want people to get to and wipe by mistake.
Thanks
Sue

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson