Macro which automatically send Excel spreadsheet to Outlook problem

Justin
Justin used Ask the Experts™
on
Hi Guys, on the attachment, I have a macro which copies and pastes Values the sheet "ECB calc" to an attachment in Outlook and sends it .

However, when the recipient opens the attachment, there is a message saying "This workbook contains links to one or more external sources".

How do I get rid of this warning message? Also, I don't want to copy and paste the actual macro so the recipient does not see it. How do I do this?
Balance-Sheet_12Sep2016_FCD-Extract.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Check attached, where all (visible) names are deleted, links broken (no need to copy, paste values then), and button deleted.
Balance-Sheet_12Sep2016_FCD-Extract.xlsm
JustinFinancial Control

Author

Commented:
excellent

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial