I'm running a macro which opens up a list of workbooks one at time, updates all links, calculates, saves & closes. Each workbook has a number of links and for one of the links in each workbook a popup appears saying that the workbook wasn't recalculated before save. It then waits for me to hit OK before continuing. Is there any way of making VBA just select the default option without me having to click on it?
Thanks
Thanks