using advance filter when shared

[GEORGIA]

Is there a way to use the advance filter option when the workbook is shared?
I have created a command button to run the advance filter code. However, I
just notice when the workbook is shared, the macro will not run because of
the advance filter option.

Thank you!

[Debra Dalgleish]

You can't run an Advanced Filter in a shared workbook.

However, you could open a new workbook, start the Advanced Filter, and
extract the data to the new workbook.
Then, copy the results back to the shared workbook.



GEORGIA wrote:
> Is there a way to use the advance filter option when the workbook is shared?
> I have created a command button to run the advance filter code. However, I
> just notice when the workbook is shared, the macro will not run because of
> the advance filter option.
>
> Thank you!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html