Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Show all" button not work in protected worksheet
Dear all,
I have an excel file with 30+ columns, and auto filter in use. Many users may open the file and use autofilter to look for information or update information in the file. I have also protect the worksheet as some columns contain formular which I don't want the general users to modify. As there are so many columns in the file, it is difficult to see clearly which columns has been filtered in the previous save action. It seems that the "Show All" button does not work in a protected worksheet. I use excel 2002, and the "Show All" button is dim even the autofilter has applied. Is there any workaround?? Perhaps a macro which do the "Show All"? Many thanks, Marisa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to view a custom view when the worksheet is protected? | Excel Worksheet Functions | |||
Spell Check in Protected Worksheet & Shared Workbook | Excel Discussion (Misc queries) | |||
Import/Export XML in protected worksheet | Excel Discussion (Misc queries) | |||
Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) |