FWIW, I would recommend using
If Wkb.Name <> "MyLinks.xlsm" Then
rather than
If ActiveWorkbook.Name <> "MyLinks.xlsm" Then
My apologies for not revisiting this thread earlier but I completely lost track of it. I am glad to see you have a resolution.