Worksheet Protection and Show All

[Lance S]

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

 

[Dave Peterson]

Maybe you could provide a macro that unprotects the sheet, does the showall,
then reprotects the worksheet.

Put a button on the worksheet and tell the users to click that when they need to
see all the data quickly.