Programatic access to VB-editor not trusted

  • Thread starter Thread starter Filips Benoit
  • Start date Start date
F

Filips Benoit

Dear All,

Windows
Office 2007

While creating a new excel-file from Access I insert some code into that
workbook before saving it.
All this worked OK in Office 2003 but now I get this error

Progamatic access to the Visual Basic editor not trusted !

How can I make it TRUSTED ?

Filip
 
In Excel, click on the big round Office button in the top left of the
window, click on Excel Options, choose Trust Center, then click on Trust
Center Settings, select Macro Settings, and finally check the checkbox
for Trust access to the VBA project object model. Then click OK twice to
return to Excel.

- Jon
 
Thanks, works OK

Filip


Jon Peltier said:
In Excel, click on the big round Office button in the top left of the
window, click on Excel Options, choose Trust Center, then click on Trust
Center Settings, select Macro Settings, and finally check the checkbox for
Trust access to the VBA project object model. Then click OK twice to
return to Excel.

- Jon
Click to expand...
 
Back
Top