I have a large user form. Once the user fills it out a
macro gathers the information on two sheets and emails
those two sheets with a new filename. The new emailed file
contains no macros but when the recipient opens it they
are still faced with the "This workbook contains
macros..." promt.

Is there something I can add to the code that copies and
sends my two sheets to stop this message?

Thanks