I have two scheduled tasks on my computer. They both open Excel files and run a macro & are pretty similar in what they do. They both work on my computer. However I moved the scheduled tasks onto a colleague's computer. One worked the other didn't.
The one that didn't work opened Excel but had an error saying:
>
"programmatic access to visual basic project is not trusted".
Like I say, both Excel files are very similar. The one that didn't work does reference two additional projects the other one does not. They are,
```
Microsoft Visual Basic for Applications Extensibility 5.3
Microsoft Windows Common Controls-2.6.0 (SP6)
```
I have never come across this error before.
Programmatic Accès To Visual Basic Project Is Not Trusted
Re: Programmatic Accès To Visual Basic Project Is Not Trusted
File -> Options -> Trust Center -> Trust Center Setttings -> Macro Settings -> Trust Access to the VBA Project object model.
This is usually needed if you are referencing Extensibility library.
This is usually needed if you are referencing Extensibility library.