xl2002 added more security measures.

You can toggle this (user by user) via:
Tools|Macro|Security|Trusted Sources Tab



"wrkoch <" wrote:

Didn't work. Threw a 1004 run time error on the SET line

"Programmatic access to Visual Basic Project is not trusted."

Dim x As Object
Set x = Application.VBE.ActiveVBProject.VBComponents

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson