View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Excel 2007. Trust Access to VBA Project Checked, still not truste

Why not move it into a trusted location?

--
__________________________________
HTH

Bob

"Barb Reinhardt" wrote in message
...
I've just migrated to a new laptop and Excel 2007 in the last 24 hours and
am
unable to run a macro that worked in 2003 on 2007 (that's a newsflash,
huh?)
Anyway, I'm trying to programmatically access information about the VBA
Project and when I get to this line

Set VBProj = mySlide.Parent.VBProject

I get an error that the project is not trusted. (OK, this is PowerPoint,
but it's running out of Excel). I've changed the settings to trust this
project and I still get the error. Is there something that our admins
need
to do so that I can run this? Do I need to trust this out of PowerPoint?

Thanks,
Barb Reinhardt