Insert template - do not update links

Magriza

Well-known Member
Joined
Nov 16, 2005
Messages
508
Hi all,

I'm using the following snippet to insert a template into my workbook.
Code:
        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!
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,122,608
Messages
5,597,143
Members
414,129
Latest member
mr vba

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top