| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet protected-auto filter works, show all button dosen't.
One of the options in protection is to allow the user to edit objects. Ensure
that it is checked along with use autofilter... I am assuming you are talking about a macro button and that your version of XL is XP or better... -- HTH... Jim Thomlinson "Pink Gorman" wrote: Have a worksheet with multiple columns of data and auto filter set. Have a "show all" button selected. As long as sheet is not protected everything is fine. If I protect the worksheet the auto filter works fine but "show all" dosen't. Solution? Thanks Pink Gorman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use auto filter in a protected worksheet | Excel Discussion (Misc queries) | |||
| Using auto filter after my worksheet is protected | Excel Worksheet Functions | |||
| Help with using Auto-filter in a protected Worksheet. | Excel Discussion (Misc queries) | |||
| "Show all" button not work in protected worksheet | Excel Worksheet Functions | |||
| Auto Filter with Protected Worksheet | Excel Worksheet Functions | |||
Threaded Mode
