The macros should be saved in a template (.dotm) and that file is what gets shared to your workgroup users. You can make this template available to users either by setting their options to point their Workgroup Templates folder to a network location or by copying the template into their User Templates folder.
This might help you a bit...
Distributing macros to other users