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