Programmatic Access To Visual Basic Project Is Not Trusted
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.
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.
- Facing issues with creating multiple hyperlinks in a single cell in word
- VBA API declarations. Bring window to front , regardless of application
- Start a condition with specific text VBA
- Select 3 rows based on criteria then remove entire rows, find next, repeat down to last row. one code line causes Run-time error '1004'
- Regex to capture VBA comments
- Programmatic Access To Visual Basic Project Is Not Trusted
- What are the Pros and Cons of VBA Code vs Macros in MS Access?
- Extract data with VBA from weather website
- Deleting content on powerpoint using VBA
- Copying between two different workbooks with VBA
- Run VBA code on tables in multiple sheets
- Copy a file and a folders to location based on excel list
- Copy table rows to clipboard if specified cell in that row not empty
- Auto calender appointment not booking correctly. Does respect start but does not look at End time
- I want to copy data depending on a value from one sheet to another, and instantly delete the copied data and remove the now empty rows
- search within rows and columns based on two search criteria and select a single cell vba
- Cannot Run Visual Basic Editor Because of a Syntax error whilst recording macro
- Add newline to VBA or Visual Basic 6
- ReDim Preserve doesn't Preserve at all
- Export html content to pdf using Microsoft Edge
- Word Macro - Superscripting all footnote numbers at the footnote-section at the bottom of the page
- VBA For Each Loop and Else condition
- VBA method FolderExists type mismatch error
- Infinite loop while closing another workbook
- Running two separate macros from 2 columns on the same sheet
- Predefined conditional compilation constants to determine if my VBA code is running in Word or Excel
- Populating ListBox. "Run-time error '380': Could not set the List property. Invalid property value."
- Outlook read calender working on Windows Business 11, but not windows 10
- Cutting Row with Data and moving to different sheet VBA
- How to move data from next row to top automatically after clearing?