Programatically filter a protected shared workbook

[Neill]

How can I filter a protected shared worksheet?

I have allowed filtering in protection & can filter the protected worksheet
manually but if I try using vba it says its protected. I can't unprotect then
filter because it's a shared workbook.

You can't protect or unprotect a shared workbook.

I have tried ws.Protect UserInterfaceOnly:=True

Command used to try to filter is:
Selection.AutoFilter Field:=3, Criteria1:="LK", VisibleDropDown:=False

Why can I manually filter not not using the above command.

Regards
Neill

 

[Dave Peterson]

The answer hasn't changed since you asked in November.

 

[Neill]

The question was never answered, nobody came up with an answer not worked, am
I not allowed t ask the qustion again. I can understand your comment if the
question was answered.

 

[Dave Peterson]

http://groups.google.co.uk/group/mi...6/f35c3a971e286d0c?lnk=st&q=#f35c3a971e286d0c

or

http://snipurl.com/1z421

You can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100

 

[Neill]

I understand what your saying I just feel telling me I can't do it is not
really an answer. What I can't understand is why I can filter it manually but
not with a line of code.

Thanks for your detailed reply anyway & if I can't find a actual answer to
the question I may have to consider alternatives.