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
|How to read BOM (Byte Order Mark) from csv file.||4||36|
|Excel - list cell contents that are not duplicated||4||30|
|Help with Adding text from a form to a worksheet||5||37|
|Filling Blank Cells||14||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!