Access to the VB project is not trusted

Apr24
2009 2 Comments Written by admin

I was trying to enable an add-in for Excel 2007, and I kept getting this error:

Access to the VB project is not trusted

You can turn this message off by going to Developer tab in the ribbon and then clicking on the Macro security button, and checking the check box for “Trust access to the VBA project object model.”

A word of caution: be wary of the add-ins/projects that need VBA access. Don’t allow any project/add-in with VBA access, unless you know its exact purpose or the author of that project.

Related posts:

  1. Super-Easy Guide to the Microsoft Office Excel 2003 Object Model
  2. Access VBA: Delete tables from Access database
  3. Access VBA: Export Access tables using ODBC
  4. Access Export to Excel (2007)
  5. Access VBA: Convert Access tables to arff format
Posted in Error messages - Tagged , ,
«
»

2 Comments
  1. Ravi Sagar's Gravatar Ravi Sagar
    May 10, 2009 at 7:25 am | Permalink

    Is it possible to have this option turned off automatically for system admins or windows users with some special rights. When I send a sheet that contain a Macro to someone over email then they first have to enable the Macro Security to Medium.

  2. a7n9's Gravatar a7n9
    May 10, 2009 at 1:47 pm | Permalink

    @Ravi Sagar
    Not that I know of. If we could do it automatically, it would defeat the purpose of having that security setting.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">