Need help with two issues: 1) Not updating links and 2) breaking links in workbook

I have a VBA code that, upon a key-stroke prompt, will copy a worksheet from a source workbook to a destination workbook, rename the worksheet with a date, and close the source workbook. My problem is that when the macro opens the source workbook, the source workbook asks if I'd like to update links - I do not. And once the worksheet is copied over the workbook maintains a links to the source workbook.

How can I set up my code to prevent the Update Links prompt from popping up and break the data link to the source workbook?

My code is below:

Please Login or Register  to view this content.

Thanks in advance for any advice. I use Excel 2016.

Try this. Not tested.

Please Login or Register  to view this content.

You're welcome.

If the links are gone, why would you get an update links message?

Put this at the end of the macro.

Please Login or Register  to view this content.

Originally Posted by mmayo713

Where would I place that if I want to tell it to not update links for the source workbook?

Use this for the source workbook.

Please Login or Register  to view this content.

How to suppress Update Links warning.