View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
giblon
 
Posts: n/a
Default 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.