View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech
 
Posts: n/a
Default How to Sort within AutoFilter with Protection on (and AutoFilter .

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

--
Jim
"giblon" wrote in message
...
| 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.