I have a spreadsheet that gets protected before it is sent out to staff. It uses AutoFilters which I want to keep enabled while the spreadsheet is locked. Since there are quite a few columns, I added a button to clear all of the filters so they don't have to click each one individually. The problem is my button only works when the sheet/workbook are not protected.
I get a run-time 1004 error when it is protected:
"ShowAllData method of Worksheet class failed"
Is there another option I can use?
I get a run-time 1004 error when it is protected:
"ShowAllData method of Worksheet class failed"
Code:
If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If
Is there another option I can use?