VBA pasting code problem with Links in source document

[will31]

Hi All,

I have a nice, simple pasting macro that recently has started to come up with an Edit links dialogue box for every sheet it opens. I have no control over the source workbooks and therefore wondered if there is a way to break all links after each pasting or turn the action off in some way in the VBA code. It has slowed the macro down to a crawl...

Any ideas?

 

[Misca]

Have you tried turning off the alerts?

Application.DisplayAlerts = False

 

[will31]

Works a treat

Thanks!