ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   'Programmatic access to Visual Basic project is not trusted.' message (https://www.excelbanter.com/excel-programming/291293-programmatic-access-visual-basic-project-not-trusted-message.html)

joe

'Programmatic access to Visual Basic project is not trusted.' message
 
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

DennisE

'Programmatic access to Visual Basic project is not trusted.' message
 
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


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com