'Programmatic access to Visual Basic project is not trusted.' message

J

Joe

I'm using Windows 2000 and Excel 2000

When trying to do anything in the VBE objects with VBA code, I receive the following message

'Programmatic access to Visual Basic project is not trusted.

Could someone please tell me how to deal with this? I need to check for references in code becuase the user will not have any access to the VBAProject files

TIA

Joe
 
D

DennisE

Joe,

Are you sure you're using Excel 2000?
"Programmatic access to Visual Basic project is not trusted" is an error
message
that to the best of my knowledge is issued in Excel 2002 and 2003 if the box
marked
"Trust access to Visual Basic Project"
is not checked on the Trusted Sources (in 2002) or Trusted Publishers (in 2003)
tab
reached by Tools-> Options-> Security-> Macro Security-> Trusted Sources

-- Dennis Eisen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top