Macro which automatically send Excel spreadsheet to Outlook problem

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
JCutcliffeAsked:
Who is Participating?
 
Ejgil HedegaardConnect With a Mentor Commented:
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
0
 
JCutcliffeAuthor Commented:
excellent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.