?
Solved

Macro which automatically send Excel spreadsheet to Outlook problem

Posted on 2016-09-13
2
Medium Priority
?
104 Views
Last Modified: 2016-09-14
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
0
Comment
Question by:JCutcliffe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 23

Accepted Solution

by:
Ejgil Hedegaard earned 2000 total points
ID: 41796965
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
 

Author Closing Comment

by:JCutcliffe
ID: 41797661
excellent
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question