Would Application.DisplayAlerts = False when opening your workbook?


Craig McK wrote:
HI

Thanks for the response on previous questions, it's really helping me along

Now for the next one

One of the workbooks I ref has a link inside it. It looks like a link my
supplier uses to populate it before posing it to me, anyway. When I call the
sheet it asks to update links or not. How do I automate this to No. I used
the following line

Application.AskToUpdateLinks = False

But that must reply with the default answer, which in this case is update
links, so another message comes up saying it can't find the linkd file.

Thanks
Craig