View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jase Jase is offline
external usenet poster
 
Posts: 43
Default stop enable macro message

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
-----Original Message-----
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
.