Skip to main content

Excel Macro: Enable Trust Access to the VBA Project Object Model

Enabling trust access to the VBA project object model allows you to write automated Excel programs and manipulate the VBA environment and object model.

This method uses SendKeys to try this trick. However, SendKeys is unstable, so don't be surprised if it doesn't work 100% of the time.

Enable Trust Access to the VBA Project Object Model

'------------------ Modules ------------------
Sub EnableTrustAccess()
    Dim intCount As Integer
    On Error GoTo Error
    intCount = ActiveWorkbook.VBProject.VBComponents.count
    Exit Sub
Error:
    Application.SendKeys ("%tms%v~")
End Sub

How This Macro Works

We ues ActiveWorkbook.VBProject.VBComponents.count to attempt to access VBA Components, If an error occurs: Run-time error'1004: Programmatic access to Visual Basic Project is not trusted, it means that Trust Access to the VBA project object model is disabled. Next, we use SendKeys method to enable it. The parameter of %tms%v~ means:

  • %tms open Trust Center Macro settings.
  • %v select the Trust Access to the VBA Project Object Model check box.
  • ~ apply the setting.

Please don’t run this macro directly from your VBA editor. Run this Macro on Developer tab -> Code group -> Macros.

Most VBA code should be placed in Standard Modules unless specified.

If you see a comment '------------------ Modules------------------ in the code header that means put the code in a Standard Module. For more information, learn this course: Where should I put the Excel VBA code?

The following steps teach you how to put VBA code into a Standard Module:

  1. Activate the Visual Basic Editor by pressing ALT + F11.
  2. Right-click the project/workbook name in the Project Window.
  3. Choose Insert -> Module.
  4. Type or paste the code in the newly created module. You will probably need to change the sheet name, the range address, and the save location.
  5. Click Run button on the Visual Basic Editor toolbar.
  6. For more information, learn this course: Programming with Excel VBA

Leave a comment

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

Format your code: <pre><code class="language-vba">place your code here</code></pre>