2003--2007"programatic accses to visual basic project is not trus
 

hi,
i got the following message:"programatic accses to visual basic project is
not trusted "when i'm running macro in excel 2007.
the same macro run on the same file in 2003 without any error.

the code is:
For Each x In Application.VBE.ActiveVBProject.VBComponents
....

please advice .
i need the code to work in both environments.
thanks.
--
Miri Tz.

2003--2007"programatic accses to visual basic project is not trus
 

Enable Trust in the Trust Center (in Excel Options). This isn't a new
setting so you must have done this in Excel 2003 too.

--
Jim
"Miri" wrote in message
...
| hi,
| i got the following message:"programatic accses to visual basic project is
| not trusted "when i'm running macro in excel 2007.
| the same macro run on the same file in 2003 without any error.
|
| the code is:
| For Each x In Application.VBE.ActiveVBProject.VBComponents
| ...
|
| please advice .
| i need the code to work in both environments.
| thanks.
| --
| Miri Tz.