Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code runs in Excel 2002 but not in Excel 2003.
We get the error: "Run Time Error '1004' Programmatic access to Visual Basic Project is not trusted". 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 We have checked the "Trust Access to Visual Basic Project" check box in the ToolsMacroSecurityTrusted Sources tab (at the bottom), but to no avail. Any Ideas? A poster in this newsgroup suggested that we check the registry, but not sure how to do this. Instruction in this area would be appreciated. Thank you, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel 2003 + macro help | Excel Discussion (Misc queries) | |||
Excel 2003 + macro | Excel Discussion (Misc queries) | |||
how to run acces 2003 macro in excell 2003 macro | Excel Discussion (Misc queries) | |||
Excel 2003 Macro | Excel Worksheet Functions | |||
Excel 2003 macro | Excel Programming |