method vbproject of object workbook fail

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
activeworkbook.vbproject...... is used.
i have ticked the "Microsoft Visual Basic For
Click to expand...
Applications Extensibility 5.3". in references
 
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 said:
I get this error every time The code
Click to expand...
activeworkbook.vbproject...... is used.
i have ticked the "Microsoft Visual Basic For Applications
Click to expand...
Extensibility 5.3". in references
 
Back
Top