Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Error when running macro in Excel | Excel Programming | |||
KERNEL32.DLL error after running EXCEL Macro | Excel Programming |