Re: Excel 2007. Trust Access to VBA Project Checked, still not tr

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

No, we didn't discuss in the context of 2007.

Maybe not in 2007 but it's the same issue in all versions since 2002. Only
difference is where to find the setting in the UI.

Should I set up a "trusted
location" in PowerPoint as well?

Programmatic access to a VBProject is not a "trusted location" issue.

Regards,
Peter T


"Barb Reinhardt" <BarbReinhardt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FD218E38-282A-4E3D-A300-4A924DFCAF19@xxxxxxxxxxxxxxxx
No, we didn't discuss in the context of 2007. Should I set up a "trusted
location" in PowerPoint as well?

"Peter T" wrote:

Exactly as you would in any Office application, including Excel. Didn't
we
discuss this once before? It's a one-off application level setting, that
'ought' to be done manually by the user -

in 2007
Office button
App' Name Options
Trust Center
Trust Center settings
Trust access to the VBA project object model

In 2002/3
Tools
Macro
Security
Trusted publishers
Trust access to VB Project

In this case looks like 5 steps in all versions, somehow it seems like
its
considerably more in '2007 !

Regards,
Peter T


"Barb Reinhardt" <BarbReinhardt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:E6E54ED3-149A-4AB4-96DD-4364B605A4E0@xxxxxxxxxxxxxxxx
OK, so how do I do that when I'm not sure which powerpoint presentation
I'm
going to be using each time?

"Peter T" wrote:

Do I need to trust this out of PowerPoint?

Yes

Regards,
Peter T

"Barb Reinhardt" <BarbReinhardt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:3F2A1299-4BD7-4015-8DCA-25B391998FA5@xxxxxxxxxxxxxxxx
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









.

Relevant Pages

  • Re: Excel 2007. Trust Access to VBA Project Checked, still not tr
    ... have programmatic access to the VBA Project in PowerPoint. ... "Peter T" wrote: ... Programmatic access to a VBProject is not a "trusted location" issue. ...
    (microsoft.public.excel.programming)
  • Re: Excel 2007. Trust Access to VBA Project Checked, still not tr
    ... location" in PowerPoint as well? ... "Peter T" wrote: ... Trust access to the VBA project object model ... Trust access to VB Project ...
    (microsoft.public.excel.programming)
  • Re: Excel 2007. Trust Access to VBA Project Checked, still not tr
    ... so how do I do that when I'm not sure which powerpoint presentation I'm ... "Peter T" wrote: ... Do I need to trust this out of PowerPoint? ...
    (microsoft.public.excel.programming)
  • Re: A new Beta test from Panda
    ... For the record, too, I have never said that I do not trust you - we learnt ... It wasn't only me who spotted that Peter Foldes has exactly the same IP ... He has two connections and one is via Sympatico. ... in Canada, being part of Bell Canada. ...
    (microsoft.public.security.virus)
  • Re: Freds Legacy
    ... > Knowing the likely wishes of the man, he has probably left most in trust ... > sonI can't see his last wife wanting to get too involved. ... > Peter & Rita Forbes ...
    (uk.rec.engines.stationary)