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

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=565312

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.

changetires wrote:

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

Ed

--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=565312

--

Dave Peterson

Thanks Dave,

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

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=565312

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.

changetires wrote:

Thanks Dave,

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

Ed

--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=565312

--

Dave Peterson