sendmail commandbutton not to display macro?

[godzilla65]

Howdy Guys and Gals,
Is their anyway known to man to send a worksheet as say text/values only without the enable macros box appearing on the emaill sent?

My workbook is titled Charter template.xls and their is a worksheet called "invoice" this workbook has lots of macros, command boxs etc and their is only the send command button on the invoice page to send the invoice the range on worksheet("Invoice') is A1:G61 that we send out as an invoice but the email arrives to the recipient with would you like to enable/disable macros, is their a way to maybe send this range as maybe text only as an attachment via say sendmail? so the enable macro message does not display, as u may have guest trying to send an invoice, it grabs its email adress from cell range F16:G16 from another worksheet called "Quotes"

Any and all suggestions more than welcome,

Thanks Eric Brisbane Aust ray:

 

[tactps]

The best idea is to record a macro doing the following:
1. Create a new workbook
2. Copy the first workbook
3. Paste special (calues, formats, comments) to the new one.
4. E-mail the new one.
5. Save if required.

Use "Macro" from the "Tools Menu".

If you need more help, post the macro you created.