I have read multiple posts on here about using "Autofiltering=True" when the
Protect function is used to allow Autofiltering.

I can see this (and multiple other sub options) in the Help File for Excel
2003. However I am writing an application for Excel 2000 and this option does
not appear available. I would like the Autofilter for various columns to be
selectable, either by the user or macros, whilst the Worksheet is protected.

Is there anyway around this apart from making users upgrade their version of
Excel ? I am assuming the answer is 'No' but if someone tells me otherwise I
will be very happy.

Thanks in advance.