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

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

I think you'll have to either show all the data--one field at a time.

Or maybe provide a macro that unprotects the sheet, does a showall, then
reprotects the sheet.

That builtin ShowAll button won't work if the sheet is protected.

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

--

Dave Peterson