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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
| 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.
 
Back
Top