I have a data list in a shared, protected excel file with autofilter turned on.

I am using in the sub auto open:

ActiveSheet.EnableAutoFilter = True
ActiveSheet.Protect Contents:=True, userInterfaceOnly:=True

After I save and reopen the file, I can manually apply and clear filters; but cannot do so using vba.

Any suggestions to address this anomaly will be appreciated.

Thank you.


Leave a Reply

Your email address will not be published. Required fields are marked *