I have a worksheet that has two buttons. The first button is used by a user
to submit (sent using the sendmail VB command) a request for approval. The
first button works fine. The document is attached to an Outlook message and
the message is forwarded to the "approver" for review.

The second button also has a VB send script that is used to send the
document for processing once it has been review and approved.

My issue is once the document is sent for approval it loses it's macros.
The second button no longer contains the VB macro. Is there a way to send an
EXCEL document via the sendmail command that ensures all macros are sent as
well?

Thanks in advance for you help.