Problem occurs when upgrading Excel from 97 to 2002

Y

YATES

When I was upgrading our program from Excel 97 to Excel
2002, the code that worked well with Excel 97, now fails
in Excel 2002. Please see the following line of failure.

Set theCode = ThisWorkbook.VBProject.VBComponents
("thisworkbook").CodeModule

When debugging, I found the following error message.

Run-time error 1004, Programmatic access to Visual Basic
Project is not trusted.

Does anyone have any suggestion? Thanks in advance!
 
J

Julian Milano

This one got me too in the beginning. Tools, Macro, Security, Trusted
Sources, Trust Access to Visual Basic Project!
 
Y

YATES

Thanks so much, Julian.

-----Original Message-----
This one got me too in the beginning. Tools, Macro, Security, Trusted
Sources, Trust Access to Visual Basic Project!

--

Julian Milano





.
Click to expand...
 

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

Similar Threads

Programmatically removing code from ThisWorkbook XL2007 2
Programmatic Access to Visual Basic Project is not Trusted 3
Problem Running Code in Excel 2003 1
Run-Time Error on Macro 4
Excel 2003 - Error Running Macro 2
Macro Won't Run in Excel 2003 4
Update from Excel 97 to 2007 4
Problems from changing from Excel 97 to Excel 2002 (Office 97 to Office XP). 2

Top