2003 Secutity Issue

W

William Barnes

I wrote an Excel AddIn that I use to archive the latest version of Excel
objects that I am developing. Basically the AddIn accesses the VBA Project
and exports each of the objects (classes, Documents, code modules) to a
directory chosen by the user. It used to work just fine in previous versions
of Excel but now that I have upgraded to Office 2003, when I attempt to run
it I get the following:

Runtime error 1004: Programmatic access to Visual Basic Project is not
trusted.

I tried setting the security to 'Low' and also tried referencing the AddIn
in VB but neither solved it. What do I need to do to restore functionality
to my AddIn?
 
D

Dave Peterson

This is a user setting.

Tools|Macro|Security|Trusted Sources Tab
There are two checkboxes at the bottom of the dialog.

But it is a change for each user.
 
Top