Consulting

Results 1 to 1 of 1

Thread: error when vba editor opens by code 'not trusted'

  1. #1
    VBAX Tutor MINCUS1308's Avatar
    Joined
    Jun 2014
    Location
    UNDER MY DESK
    Posts
    254

    error when vba editor opens by code 'not trusted'

    I'm using the following line to open vba editor

    Application.VBE.MainWindow.Visible = True

    When vba editor is opened via code i'm receiving a message box that says:
    "Programmic access to Visual Basic Project is not trusted."

    Is there a way to trust it?

    Resolution:
    There is a way.

    open the excel file and navigate to File>Options>Trust Center>Trust Center Settings

    check the box that says " Trust access to the VBA project object model"

    NOTE: THIS COULD BE POTENTIALLY DANGEROUS.
    IT WILL ALLOW SELF REPLICATING CODE TO REAK HAVOC ON YOUR SYSTEM.
    Last edited by MINCUS1308; 08-01-2014 at 02:08 PM.
    - I HAVE NO IDEA WHAT I'M DOING

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •