When I run a VBA sub to load several files the program often is interrupted with this nag:
"This Workbook contains links to other data sources...."
I can "Update", "Don't Update" or "Help".
I wish to just have the code ignore the message. Other than removing the links, which I cannot always seem to do, I have tried:
But nothing seems to work. Suggestions?
"This Workbook contains links to other data sources...."
I can "Update", "Don't Update" or "Help".
I wish to just have the code ignore the message. Other than removing the links, which I cannot always seem to do, I have tried:
Code:
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Application.EnableEvents = False
With Application
.Calculation = xlManual
.MaxChange = 0.001
End With
But nothing seems to work. Suggestions?