Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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.