May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.
Private Sub LibCheck() ' Source: MSDN Dim vbProj As VBProject ' This refers to your VBA project. Dim chkRef As Reference ' A reference. ' Refer to the activedocument's VBA project. Set vbProj = Application.ActiveWorkbook.VBProject ' Check through the selected references in the References dialog box. For Each chkRef In vbProj.References If (chkRef.IsBroken) Then ' Remove the reference from the reference list vbProj.References.Remove chkRef End If Next chkRef End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.