I have a vba that attaches a reference with a logical name as "BORDER". The reference dialog box shows the attached reference with logical name as "BORDER". I will then run a second vba that looks for reference logical name as "BORDER". The second vba…