stop enable macro message

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
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
 
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
 
Back
Top