method vbproject of object workbook fail

[Guest]

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

 

[Patrick Molloy]

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

 

[Guest]

Sub vbext_ct_StdModule()


MsgBox ActiveWorkbook.VBProject.VBComponents.Count


End Sub

 

[Chip Pearson]

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

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

 

[Guest]

It worked... thanks