My company used a spreadsheet to track jobs that are
either Lost, Comleted or In Progress. A number of macros
are assigned to CommandButtons that allow the listing to
be sorted by Salesperson, Job#, Status, etc.

Everything's been working fine, but lately we've found
that a number of users need to be in the workbook
simultaneously. My thought was to Share the workbook,
which was done, but now, whenever I press any of the
CommandButtons, I get the following error message:

"Run-time error 1004
AdvancedFilter method of Range class failed"

I'm hoping that someone has an easy fix, without having to
delve too deeply into the code, but please let me know if
you need anything else.

Thanks,

Joe