Autofilter

C

changetires

Is there a way to have the autofilter feature work when the workbook i
being shared?

E
 
D

Dave Peterson

If you've already applied the filters to the range before sharing the workbook,
then those filter arrows will work.

But....

If you've protected the worksheet in that shared workbook, it won't work.
 
C

changetires

Thanks Dave,

Yeah the workbook is being shared and protected. So the protection is
what is not letting it work.

Ed
 
D

Dave Peterson

The bad part is that you can use autofilter on worksheets that are in shared
workbooks.

You can use autofilter on protected worksheets (if you apply the protection in
code with a special parm).

But once you share the workbook, you can't change the worksheet protection--so
it kills the autofilter, too.
 
Top