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?

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.

William Barnes wrote:

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

http://support.microsoft.com/default...Product=xl2003
PRB: Programmatic Access to Office XP VBA Project Is Denied

applicable to xl2002 and xl2003

--
Regards,
Tom Ogilvy

"William Barnes" wrote in message
...
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?

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

"William Barnes" wrote in message
...
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?