Spit a workbook into multiple workbooks, while retaining the macros

If there is a way to add a particular macro to multiple existing workbooks in a folder, please tell me. I am NOT merely trying to run a macro on multiple workbooks from my end--I know how to do that. Each individual workbook needs to have the macro in it so that when I email the workbooks to other users it will work in each one.

EDIT: I am told by a neighbor that this may be a job for VB 6. I'm not sure if this is the proper forum for solutions involving VB 6, but if anyone here is well versed in it they can send their proposed solution (in proper detail, please!) in a PM.

This is a forum where solutions are provided through formulae or even code (VBA).

Its against the forum rules to send you solutions via PM. All users responding to your questions, will do so here itself for the benefit of the other users.