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,


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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question