How do you handle the message box for Automatic links. I have to paste 32 worksheets a day in to a Summary spreadsheet. One of the workbooks opens with the statement: The workbook you openeded contains automatixc links to @@@###@#@#@#@ AND SO ON; there are 2 choices then, Yes and No.
How do you get by this? Or how do you tell the computer to pick no everytime?

thanks in advance
A Newbie to Macros