Hi,
Could you please help me enable the autofilter after a macro has been run? the macro unprotects and protects at the end but this still wont work. I can't seem to edit the filter as it is disabled/unclickable. my macro would adjust the filter but sometimes they wanted to edit the filter from the row itself.
By the way, before I protect the sheet, I made sure that autofilter is on as I have read from other posts.
Sub Filter()
Sheets("Selector").Select
Call Unprotect
ActiveSheet.Range("$A$86:$AB$5895").Select
Selection.AutoFilter
'Meas
If ActiveSheet.Range("G85").Value = "ALL" Then
ActiveSheet.Range("$A$86:$AB$5895").AutoFilter Field:=7
Else
ActiveSheet.Range("$A$86:$AB$5895").AutoFilter Field:=7, Criteria1:=Range("G85")
End If
'CASE
If Range("J85").Value = "ALL" Then
ActiveSheet.Range("$A$86:$AB$5895").AutoFilter Field:=10
Else
ActiveSheet.Range("$A$86:$AB$5895").AutoFilter Field:=10, Criteria1:="=C_*", _
Operator:=xlAnd
End If
Call Protect
End Sub
Thank you.
Bookmarks