method vbproject of object workbook fail
 

I get this error every time The code activeworkbook.vbproject...... is used.

i have ticked the "Microsoft Visual Basic For Applications Extensibility 5.3". in references

can someone help

method vbproject of object workbook fail
 

You'll need to show us your code

The following for example
MsgBox ActiveWorkbook.VBProject.VBComponents.Count
works fine without any extra references.

Show us the context in which you use the object, and then
we may be able to identify and resolve your issue.

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
I get this error every time The code
activeworkbook.vbproject...... is used.

i have ticked the "Microsoft Visual Basic For
Applications Extensibility 5.3". in references

can someone help
.

method vbproject of object workbook fail
 

Sub vbext_ct_StdModule()


MsgBox ActiveWorkbook.VBProject.VBComponents.Count


End Sub

method vbproject of object workbook fail
 

In Excel, go to the Tools menu, choose Macros, the Security, then
the Trusted Publishers tab. There, ensure that "Trust access to
Visual Basic Project" is checked.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chrispy" wrote in message
...
I get this error every time The code
activeworkbook.vbproject...... is used.

i have ticked the "Microsoft Visual Basic For Applications
Extensibility 5.3". in references

can someone help

method vbproject of object workbook fail
 

It worked... thanks