i know how to share a workbook in excel. But is it possible to share a workbook with macro's?

Cheers all