i set up a cool workbook to solve a problem and now that i have turned on the
shared workbook feature my cool workbook is not cool!

I created a control panel with control buttons to run reports using macros
based on a set of criteria - the criteria i established on a workbook page
and when i built the macro - i used the advanced filter feature to go to the
criteria page.

Now I am finding that advanced filter doesnt work in a shared environment.
Is there anothe way that i can insert my criteria into the macro without
using this advanced filter feature?
Thanks!