using advance filter when shared

G

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!
 
D

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.
 
Top