Try putting

application.displayalerts=false

in the ThisWorkbook sheet in Object in VB.

Not sure if it will work or not... I can't test... but it is worth a shot

"FlaProcessEng" wrote in message
...
I have an annual summary sheet that links to 365 separate daily report
sheets. These daily sheets are being created automatically once per day.
I
use the following formula for the February 1 2005 cell:


=IF(ISERROR('C:\reports\daily_2005\[DAILY_FEB01.xls]Report'!R20C16)=TRUE,"",
'C:\reports\daily_2005\[DAILY_FEB01.xls]Report'!R20C16)

This works, but of course the rest of the files for 2005 don't exist yet.

What I want is to be able to open the annual spreadsheet up every day, and
say
'YES' to the 'update links to other spreadsheets' question, and to NOT
have
Excel tell me it couldn't find the rest of the 2005 daily files (the File
not
Found dialog box).
Is there a way to do this or supress this dialog box!
Thank you.