We may be having some trouble with terminology here.
"Attach a macro  in Excel".... "email a document"...

Are you saying that you have an Excel file.
It has a button  which executes a macro.
But when you send the Excel file to someone via email, the
macro is not present?

Probably that means that you recorded (or created) the macro
in your Personal workbook instead of the Excel file itself.

check in your VBA editor...

Another possibility is that the person that received your file
has their security set to HIGH, or Medium and then selected to
"disable macros" when the prompt came up. Either way, NO macros
will not run  if the user does this. You may have to educate the
user.