One way to share VS Macro projects is to add the projects to source control and have all users mapped the versioned macro projects to a local folder to be used by VS. Here is a rough outline (an except from one of my forum post) on how you can accomplish
