How can I filter a protected shared worksheet?
1. I have allowed filtering in protection & can filter the protected
worksheet
manually but if I try using code it says its protected.
2. I can't unprotect then filter because it's a shared workbook.
3. I have used Protect UserInterfaceOnly:=True but this reset after closing
& cannot be reapplied as you cant protect a shared workbook.
4. Code used to filter Selection.AutoFilter Field:=3, Criteria1:="LK"
Regards
Neill