autofilter & protection

[dantb]

I was wondering if there was anyway to protect a sheet, and still be able to use the autofilter function. Thanks Dan

 

[dantb]

Thanks Qroozn, I Hit the right place, works great. Thanks again and have a Good eve. Dan

 

[Qroozn]

no probs.I wish someone found this solution for me in the last 8 months i'd been looking.

All the best

 

[dantb]

I know what you mean, sure is nice when something works like you would like it too. Thanks again Dan .

 

[Yogi Anand]

Hi Dan and anno:
Even without the benefit of a macro, one can use Advance Filter and not Auto Filter in a protected Worksheet.
anno: your suggestion is pretty neat, and especially with the use of the data as an array, one can not change the data in any part of the array, unless of course one deletes the whole array.

Regards!
Yogi Anand