I agree that help could be much better in fact I think help has degraded
with each version of Office/Excel and you are right that help does not
mention this when it comes to rows/columns.


--
Regards,

Peo Sjoblom

Portland, Oregon




"Christopher Rath" wrote in
message ...
Forgive my oversight; I missed that statement when I reviewed the help
earlier.

MS should add that same caveat to the "Delete rows" help text too.

I had been attempting to protect the formalae in some cells from
accidental
deletion. Now I shall have to tell users to simply avoid making mistakes
(and deleting those cell contents by accident); since protecting them
removes
other necessary functions.

Christopher

"Peo Sjoblom" wrote:

Of fix the documentation so there are no misunderstandings, on the other
hand if I look in help I see this

"Sort When cleared, prevents users from using any of the Sort commands
on
the Data menu, or the Sort buttons on the Standard toolbar. Users can't
sort
ranges containing locked cells on a protected worksheet, regardless of
this
setting."

Which to me is rather obvious



--
Regards,

Peo Sjoblom

Portland, Oregon




"Christopher Rath" wrote in
message ...
According to the MS Excel help text entitled "Overview of security and
protection in Excel" if on the Protect panel I check the Sort checkbox
then
users are supposed to be able to sort data on the worksheet. If I can
only
sort unlocked cells, then the feature is out of step with the
documentation;
it's also next to useless, since it means that on a form where rows
contain
both locked and unlocked cells I am not able to allow users to sort
anything
(since that would involve sorting locked cells).

I stand by my original statement: MS needs to fix this feature so that
it
works like the documentation says it works.

Thanks for trying to help.

Regards,
Christopher

"Peo Sjoblom" wrote:

It works, you have to unlock the cells in question before you protect
it
under formatcellsprotection,
select the ranges you want to sort and uncheck locked, then protect
the
sheet with these options

--
Regards,

Peo Sjoblom

Portland, Oregon




"Christopher Rath" <Christopher wrote
in
message ...
When setting Excel Protection, the options include allowing sorting,
allowing
deleting of rows, etc. In my experience with Excel 2003, these
options
do
NOT work as advertised: even though I have ticked those options
Excel
still
forces me to remove protection before sorting protected cells or
deleting
rows in a protected sheet.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to
the
suggestions with the most votes. To vote for this suggestion, click
the
"I
Agree" button in the message pane. If you do not see the button,
follow
this
link to open the suggestion in the Microsoft Web-based Newsreader
and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc