How to Sort within AutoFilter with Protection on (and AutoFilter .

Sort Ascending / Descending don't seem to work when Protection is turned on,
even if the AutoFilter and Sort check box is checked when enabling Protection.

1. Tools -> Protection -> Protect Sheet -> check Use AutoFilter (and Sort if
you wish).
2. Data -> Filter -> AutoFilter.
3. Click any column heading -> Sort Ascending or Descending - no change in
data.

The cells to be sorted must be unlocked even with this protection option.

--
Jim
"giblon" <giblon@discussions.microsoft.com> wrote in message
news:9CF12308-B066-48FB-B93B-62BE3A9D1E6D@microsoft.com...
| Sort Ascending / Descending don't seem to work when Protection is turned
on,
| even if the AutoFilter and Sort check box is checked when enabling
Protection.
|
| 1. Tools -> Protection -> Protect Sheet -> check Use AutoFilter (and Sort
if
| you wish).
| 2. Data -> Filter -> AutoFilter.
| 3. Click any column heading -> Sort Ascending or Descending - no change in
| data.