The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!
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
Join the community of 500,000 technology professionals and ask your questions.