Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop enable macro 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
stop enable macro message
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 he http://www.rondebruin.nl/sendmail.htm John "Dave" wrote in 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stop error message when opening a non existant file in a macro | Excel Discussion (Misc queries) | |||
Enable Macro message | Excel Worksheet Functions | |||
Disable/Enable Macros Message box in Excel2007 | Excel Discussion (Misc queries) | |||
how to get around the Enable Macro security message? | Excel Discussion (Misc queries) | |||
How do I stop Excel from prompting to enable or disable macros? | Excel Discussion (Misc queries) |