Remove Reference from VBA Projects

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
----------------------------------------------------------------------

I think that message is related to having a Certificate of
authenticity. You either have to create your own limited
certificate(if you have the software) or you have to go through some
process with Verisign Corp. The reason you cannot do this is
protection to the system from vicious code. What you want to do can be
done manually in the VBE pane but programatically is gonna be a problem.

Since Excel 2002 there is a new macro security that you need to "approve" to
perform VBA manipulation of VBProject objects.

To set this,
choose Tools/Macro/Security from the Excel menu,
select the Trusted Sources tab
put a check in the checkbox called "Trust Access to Visual Basic Project".



--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"salut" <[email protected]> wrote in message
news:[email protected]...
> 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
> ----------------------------------------------------------------------

Thanks a lot! Looks like I have to do it manually. The excel is installed on
my company's computer, I guess I might not have enough authorization to do
things like that.

"Mark" wrote:

>
> I think that message is related to having a Certificate of
> authenticity. You either have to create your own limited
> certificate(if you have the software) or you have to go through some
> process with Verisign Corp. The reason you cannot do this is
> protection to the system from vicious code. What you want to do can be
> done manually in the VBE pane but programatically is gonna be a problem.
>
>