Sharing a document
 

Does anyone know a way to share an Excel Workbook so that more than 1 person
can have the workbook open and make changes to it and still have Macros work?

If you save it to a sharepoint server only 1 person at a time can have the
document open, but macros work.

If you make the document a shared doocument on the network, multiple people
can have the document open and be making changes, but macros do not work.

There must be a solution to this probem.