Personally I would have the macro in the workbook that has all you
other macro's.

Build the macro to create a brand new workbook, copy the required dat
into the new workbook then send the new workbook by email.

This way no macros are sent and the receiver does not have to worr
about the validity of any macro's

--
Message posted from http://www.ExcelForum.com