Forum Discussion
Excel Macro could not ignore broken link warning on OneDrive folder(works on Local folder & DropBox)
This code work on regular local drive but not on OneDrive folder. Dim fileCollection As Collection
Sub BreakExternalLinks(wb As Workbook)
'PURPOSE: Breaks all external links that wo...
Perhaps try turning off alerts right before you break the links : Application.DisplayAlerts=False
But, be sure to turn them back on as it affects other alerts (such as "do you want to save changes" when you close the workbook).
But, be sure to turn them back on as it affects other alerts (such as "do you want to save changes" when you close the workbook).
if you check the source code, Application.DisplayAlerts=False is already there (line 75 and also line 82)