Here's the code, maybe you could place it in the workbook open module

Application.AskToUpdateLinks = False


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=563975