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