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.

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" <(E-Mail Removed)> wrote in message
news:C7173839-14E7-4EC6-8DD8-(E-Mail Removed)...
| 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.