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.
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.