<div>
I found the following advice from Stephen Bullen (<a href="http://www.archivum.info/microsoft.public.excel.programming/2005-05/msg00318.html" rel="ugc">http://www.archivum.info/microsoft.public.excel.programming/2005-05/msg00318.html</a>)<br />
<br />
The Microsoft Visual Basic for Applications Extensibility library <br />
provides the object model for the VBIDE, allowing us to add menu items <br />
to the Project Explorer popup. It doesn't, however, provide the <br />
granularity of which nodes in the treeview are expanded. So, I guess <br />
that MZTools uses the object model to get the window handle and Windows <br />
API calls to find the handle of the TreeView and collapse the nodes.<br />
<br />
How can I do this?
</div>


I found the following advice from Stephen Bullen (http://www.archivum.info/microsoft.public.excel.programming/2005-05/msg00318.html [http://www.archivum.info/microsoft.public.excel.programming/2005-05/msg00318.html])

The Microsoft Visual Basic for Applications Extensibility library
provides the object model for the VBIDE, allowing us to add menu items
to the Project Explorer popup. It doesn't, however, provide the
granularity of which nodes in the treeview are expanded. So, I guess
that MZTools uses the object model to get the window handle and Windows
API calls to find the handle of the TreeView and collapse the nodes.

How can I do this?

<div>
<div class="content wysiwyg-content">
I know that MZ Tools does this. &nbsp;The VBProject object can be gotten using:<br />
<br />
application.vbe.vbprojects<wbr />.item(1)<br />
<br />
How do I collapse it in the Project Explorer?
</div>
</div>


I know that MZ Tools does this.  The VBProject object can be gotten using:

application.vbe.vbprojects.item(1)

How do I collapse it in the Project Explorer?

How can I programmatically collapse a project in Excel VBA VBE IDE

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.