Hello
I have a protected worksheet (with a password) in a shared workbook - thus the sort & filter icon on the home tab is greyed out and unusable. This makes clearing all filters a real chore because you have to look across the columns and take off the filters one by one.
I tried recording a macro and assiging it to a button which cleared the filters but I get the run-time error '1004: ShowAllData method of Worksheet class failed. I assumed this was because of the protection on, so I recorded a macro which took the protection off, cleared the filters and then put the protection back on (all with a password). However, this gives me the 1004 error again with the Unprotect method failing...
Is it possible for a macro to be assigned to a button that enters the password to unprotect the worksheet, clears all filters, then protects it again with the password.
Does anyone know if this is even possible? Any help would be massively appreciated.
Thanks guys
Bookmarks