2003 Secutity Issue

[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?

 

[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.

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;282830&Product=xl2003
PRB: Programmatic Access to Office XP VBA Project Is Denied

applicable to xl2002 and xl2003

 

[William Barnes]

As always, thanks to everyone for your prompt and excellent help.