ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Programmatci Access to Vis Basic is not trusted error message (https://www.excelbanter.com/excel-programming/293302-programmatci-access-vis-basic-not-trusted-error-message.html)

KimberlyC

Programmatci Access to Vis Basic is not trusted error message
 
Hi
I have an excel file that uses an addin file for it's macros.
In the addin file, there is some code that will delete the code in the
active workbook (code is in This Workbook) ...when executed. It works great
in Excel 2000; however, we just tried it in Excel 2002 and we get this error
message when trying to run that code:
"Programmatic Access to Visual Basic project is not trusted."

What is casuing this???
Thanks in advance for your help!!
Kimberly




DennisE

Programmatci Access to Vis Basic is not trusted error message
 
Kimberly,

Open up the VBE Editor, click on Tools, then Options, then Security, then Macro
Security, and then select the tab marked Trusted Sources. Then check the box
labeled Trust access to Visual Basic Project.

-- Dennis Eisen


All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com