G
Guest
A program that runs in Excel 2002 will not in Excel 2003. The Excel 2003 is
on an entirely different machine.
It gets hung-up on the "For Each" line in the following code:
Dim vbModule As Object
For Each vbModule In appWB.ActiveWorkbook.VBProject.VBComponents
If vbModule.Type = 1 Then ' "1" is a module
appWB.ActiveWorkbook.VBProject.VBComponents.Remove vbModule
End If
Next vbModule
The error reads: "Run Time Error '1004' Programmatic access to Visual Basic
Project is not trusted".
We have checked the "Trust Access to Visual Basic Project" check box in the
Tools/Macro/Security/Trusted Sources window.
Any ideas?
Thank you, Mark
on an entirely different machine.
It gets hung-up on the "For Each" line in the following code:
Dim vbModule As Object
For Each vbModule In appWB.ActiveWorkbook.VBProject.VBComponents
If vbModule.Type = 1 Then ' "1" is a module
appWB.ActiveWorkbook.VBProject.VBComponents.Remove vbModule
End If
Next vbModule
The error reads: "Run Time Error '1004' Programmatic access to Visual Basic
Project is not trusted".
We have checked the "Trust Access to Visual Basic Project" check box in the
Tools/Macro/Security/Trusted Sources window.
Any ideas?
Thank you, Mark