View Single Post
  #1   Report Post  
Moideen Moideen is offline
Member
 
Posts: 36
Default How to Activate Filter in Protected Sheet

I have a command button which runs some code for a filter ( recorded macro).
When I Protecting Sheet It's Not Work Properly.

Sub exp1()
'
' exp1 Macro
'

'
Rows("3:3").Select
Range("C3").Activate
Selection.AutoFilter
Range("B3").Select
ActiveSheet.Range("$A$3:$P$62").AutoFilter Field:=2, Criteria1:=RGB(255, _
153, 255), Operator:=xlFilterCellColor
Range("A21").Select
End Sub