Programmatci Access to Vis Basic is not trusted error message

K

KimberlyC

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
 
D

DennisE

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top