Insert template - do not update links

[Magriza]

Hi all,

I'm using the following snippet to insert a template into my workbook.

        Sheets.Add After:=Sheets(lastSheet), Type:="C:\Documents\...\Template.xlt"

The template contains links to the workbook it's being inserted into, and therefore asks if I wish to update links. As this in on a loop and it'll insert the template a further 245 times does anyone know if I can prevent the message from popping up?

I've tried setting the links in both the workbook and template to "Don't display the alert and update links" but to no avail.

Many thanks and kudos to whoever manages to solve this!

 

[Magriza]

Bump!