G
Guest
The following code runs in Excel 2002, but not in Excel 2003. This code was
run on a entirely different machine running Excel 2003.
It gets hung-up on the "For" statement.
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 message is "Run Time Error '1004' Programmatic access to Visual
Basic Project is not trusted"
I have checked the "Trust Access to Visual Basic Project" box on the
Macro/Security/Trusted Sources window. This worked for Excel 2002 but not
for 2003.
Any ideas?
Thanks Mark
run on a entirely different machine running Excel 2003.
It gets hung-up on the "For" statement.
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 message is "Run Time Error '1004' Programmatic access to Visual
Basic Project is not trusted"
I have checked the "Trust Access to Visual Basic Project" box on the
Macro/Security/Trusted Sources window. This worked for Excel 2002 but not
for 2003.
Any ideas?
Thanks Mark