Menu
View Categories

Fixing “Programmatic Access to Visual Basic Project Is Not Trusted”

When copying the template into your target workbook, you might get an error saying that access to the Visual Basic Project is not trusted. The fix is to enable a setting in the Trust Center or, if your company has locked that setting, to copy the modules over manually.

Option A: Enable the Trust Setting #

  1. Go to File → Options → Trust Center → Trust Center Settings…
  2. Click Macro Settings
  3. Check “Trust access to the VBA project object model”
  4. Click OK twice

Done! The setting persists, you only need to do this once.

Option B: Manually Copy Modules (If the Setting Is Locked) #

If your company has disabled the option and you can’t tick it, don’t worry, you can copy the modules manually instead.

  1. Dismiss the error and switch to your target workbook.
  2. Go to the Developer tab and click Visual Basic to open the Editor.
    • If the Developer tab is not visible, right-click the ribbon → Customize the Ribbon → tick Developer → OK.
  3. In the Project Explorer (left side), you’ll see both the Excel2PPT template and your target workbook.
  4. Expand the Modules folder under Excel2PPT. Drag each module into your target workbook (click, hold left mouse button, drag and drop). Copy all modules except mCopyTemplate:
    • LibFileTools
    • mExportToPPT
    • mRemoveShapes
    • SETTINGS
  5. Expand the Forms folder under Excel2PPT and drag the ufSuccess UserForm into your target workbook the same way.
  6. Select your target project, then go to Debug → Compile VBA Project. If you get no errors, you’re good to go.
  7. Close the VBA Editor, save your workbook, and you can now run the export without any issues.