PDA

View Full Version : [SOLVED] error when vba editor opens by code 'not trusted'



MINCUS1308
08-01-2014, 01:44 PM
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.