When an Excel sheet with Macros is passed from one PC to another, it may not work due to broken or missing preferences.
Ideally I would like to check for broken links, remove them, if possible reconnect them, and possibly dump offending code.
Unfortunately I cannot do any of that, because as soon as I trigger any macro it crashed on the unrelated offending sub-routine.
Example: Removing Broken References.... but I first have to disable the error messages...
Dim theRef As Variant, i As Long
On Error Resume Next
For i = 1 To Application.References.Count 'Remove any missing references
Set theRef = Application.References.Item(i)
If theRef.IsBroken = True Then