Sharing a document
 

Is anyone aware of a way to share a document, where more than 1 person can
make changes at the same time, and still have macros work.

If you save to a sharepoint server you get macros but only 1 person can have
the document open at any given time.

If you make the document a shared document on the network, multiple people
can have it open at the same time but macros will not work.

There must be a way to make this work.