using advance filter when shared
 

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!

using advance filter when shared
 

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