Programatically Filter a protected shared worksheet

N

Neill

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top