Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Protection and Show All
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Protection and Show All
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. Lance S wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Worksheet protection | Excel Discussion (Misc queries) | |||
Worksheet Protection | New Users to Excel | |||
Worksheet Protection | Excel Worksheet Functions |