LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default Excel 2007. Trust Access to VBA Project Checked, still not tr

The trusted location is on my Z drive. I'm getting an error in this function

Public Function VBSlideProj(mySlide As PowerPoint.Slide) As Boolean
Dim VBProj As VBIDE.VBProject
Dim VBComp As VBIDE.VBComponent

Set VBProj = mySlide.Parent.VBProject 'Error here

VBSlideProj = False
For Each VBComp In VBProj.VBComponents
If VBComp.Name = mySlide.Name Then
VBSlideProj = True
Exit Function
End If
Next VBComp

End Function


I'm actually opening some powerpoint presentations and am checking to see if
there is a VBComponent attached to each slide. If there is, I want to do
something different.

"Bob Phillips" wrote:

What exactly are you doing that needs trusted access? if you post that I can
try it here.

--
__________________________________
HTH

Bob

"Barb Reinhardt" wrote in message
...
I just set it's current location to be a trusted location and I'm still
getting the error. What next?

Thanks for your help.

Barb

"Bob Phillips" wrote:

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









 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
trust access to Visual Basic Project checked Boss Excel Programming 4 September 18th 08 01:16 PM
Trust Access to Visual Basic Project tcb Excel Programming 0 January 9th 08 06:39 PM
Trust Access to Visual Basic Project - Access to Excel and back tcb Excel Programming 0 January 8th 08 02:43 AM
Trust access to visual basic project is grayed out [email protected] Excel Programming 3 September 22nd 06 04:07 PM
Trust Access to Visual Basic Project Farah[_7_] Excel Programming 0 November 7th 05 01:17 PM


All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"