sendmail commandbutton not to display macro?

godzilla65

Board Regular
Joined
Nov 25, 2004
Messages
122
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 :pray:
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

tactps

Well-known Member
Joined
Jan 20, 2004
Messages
3,460
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.
 

Forum statistics

Threads
1,147,668
Messages
5,742,514
Members
423,734
Latest member
123hmMission

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top