Hello Nuver,

Place the closing code immediately after the end of the sheet loop. and
before the Exit Sub statement


Next sh

Windows("Master Template.xls").Activate
ActiveWorkbook.Close SaveChanges:=False
Application.DisplayAlerts = True

Exit Sub

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=482918