You can filter on a hidden sheet but not a protected one unless you allow
filtering. What methods have you tried?

--

Regards,
Nigel




"JLR-Mart" wrote in message
...
Does anyone know if it is possible to use autofilter on a hidden
worksheet. I
know that as a workaround I can make it visible, do the do, and then make
it
hidden again, but out of curiosity I wondered whether this is some sort of
restriction??

We've tried several methods without any success.

Any help greatly appreciated