Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
method vbproject of object workbook fail
Sub vbext_ct_StdModule()
MsgBox ActiveWorkbook.VBProject.VBComponents.Count End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
method vbproject of object workbook fail
It worked... thanks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error message Method €˜Add of object €˜CommandBar Controls fail? | Excel Discussion (Misc queries) | |||
Method Add of object Validation Failed - please help | Excel Worksheet Functions | |||
Is there a method for refreshing an object variable? | Excel Programming | |||
Method ~ of Object ~ Failed. | Excel Programming | |||
Object not supporting property or method | Excel Programming |