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

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

Neill wrote:

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 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" wrote:

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

Neill wrote:

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

http://groups.google.co.uk/group/mic...5c3a971e286d0c

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_gr...Excel*&num=100

Neill wrote:

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" wrote:

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

Neill wrote:

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


--

Dave Peterson

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.


"Dave Peterson" wrote:

http://groups.google.co.uk/group/mic...5c3a971e286d0c

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_gr...Excel*&num=100

Neill wrote:

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" wrote:

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

Neill wrote:

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


--

Dave Peterson