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?