Hi NewExcelBoy - Welcome to the forum. There are many ways to share macros. (a few are listed below)
1. Copy the macro code and send everyone the macro and have them add it to a module in the VBA editor (opened with Alt + F11)
From the opening Sub to the closing End Sub (See code below)
2. If you have a shared network, you can create a shared .xlsm file and include the macro(s) in that file that everyone can access.
3. You could use something like Dropbox.com to share a .xlsm file containing macro(s)
Hope this helped,
Happy Excelling ,
'This is a sub that can be shared
Cells(1, 1).value = "Shared Macro"
MsgBox ("I shared a Macro!!")