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