I was trying to remove missing references from VBA Projects. For example,
this is the code I use if I want to remove "Microsoft ActiveX Direct Object
2.7 Library"

The error message I got is "Programmatic access to Visual Basic Project is
not trusted". Could anybody help me out? Thanks a lot!

---------------------------------------------------------------------
Sub removeRef()

Dim Wkb As Workbook
Set Wkb = ThisWorkbook
With Wkb.VBProject.References
.Remove (msado15.dll)
End With
End Sub
----------------------------------------------------------------------