Programmatically removing a reference from VBA library

[SharmaAntriksh]

i have been using the below code to set the refererence to the scripting run time library -

Application.VBE.ActiveVBProject.References.AddFromFile "C:\Windows\System32\scrrun.dll"

Is there a way to remove the reference with a code?

 

[John_w]

Public Sub Remove_Project_Reference()

    Dim ref As Variant
    
    With ActiveWorkbook.VBProject
        For Each ref In .References
            If ref.Name = "Scripting" Then .References.Remove ref
        Next
    End With
    
End Sub