Hi,

I have sent out a workbook to a few friends via email
which contains various subroutines. The actual subroutine
is a 'Before Close' routine. I need to change the code in
just this subroutine. Is there a neat way to send just
the newly amended subroutine to this group but not have
to send out the whole amended workbook. The reason being,
that each of the Users has different data in the same
workbook template so I don't want to have them start over
again.

What I really need is a program that will update their
workbook and change the code in just this one subroutine.

Any ideas?