After adding Protection to a worksheet and allowing all users of the
worksheet to "Use AutoFilter", the menu selection "Data - Filter - Show All"
is no longer available; it is grayed out even after a subset of rows is
selected using one of the column AutoFilters. Because this worksheet has a
large number of columns, it can be frustrating looking for the filters
another user has applied before saving the workbook.

Is there a fix for this? My company is using Excel 2002 with SP3.

Thank you,

Lance