stop enable macro message

D

Dave

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
 
J

Jase

You could try moving all of the macros out of the module
section and write them into a worksheet. Then if the last
thing you do is delete that worksheet this will remove the
macros from the workbook. Alternatively you can create a
new workbook and copy the data into the sheets and this
will also not have any macros in it.

(if there is code behind your form this is a macro)

hope this is close to answering your question
Jase
 
J

John Wilson

Dave,

Obviously there's some code embedded somewhere on one
of the sheets that you're sending.
If you want to find out what's there, have them e-mail one of
the sheets back to you and search for the code. Could be
a leftover module or userform, the workbook, or one of the sheets.

Something that you might want to try if you're e-mailing
sheets is Ron de Bruin's Add-In. That and more than you
ever wanted to know about e-mailing from Excel can be found here:
http://www.rondebruin.nl/sendmail.htm

John
 
Top