View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William Barnes William Barnes is offline
external usenet poster
 
Posts: 15
Default 2003 Secutity Issue

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?