HI Sir,
I have a rectangle button in excel sheet assigned macro.
Without protected sheet when I click that button; my macro run easily [data will autofilter]
But, with protected sheet it will show Run-time error '1004'.
In macro my command is like below.
Range("A14:j57").AutoFilter Field:=6, Criteria1:=">0"
Please solve this.