I am using 2003 just to confirm the 3 points
1. You can not protect or unprotect a shared workbook
2. I can filter manually but not with VBA using "Selection.AutoFilter
Field:=3, Criteria1:="LK", VisibleDropDown:=False"
3. ws.Protect UserInterfaceOnly:=True disappears after closing & can not be
reapplied as workbook is shared.
Regards
Neill


"JP" wrote:

Dave can you explain further? I tested my method and it worked. As
long as you apply the autofilter first, then allow autofilter to be
used when protecting the workbook, it should allow you to use the
filter dropdowns after you share the workbook. Maybe it works because
I am doing it by hand instead of programmatically?


Thx,
JP

On Nov 15, 7:37 am, Dave Peterson wrote:
But you can't change the protection status of any worksheet in a shared
workbook.

And since that userinterfaceonly setting is forgotten after you close the file,
the code needs to be rerun each time the workbook opens. And if the workbook is
shared, the code will fail.





JP wrote:

You just have to follow the steps in the correct order, refer to my
earlier post.