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.