Code to collapse Projects in VBA Project window

[Rudi]

Hi,

Strange request, but is there a way to use VBA to automatically collapse all the projects in the VBA project window.
Often times I need to insert a new module into the current file and before I can, I have to collapse (or scroll) to find the active workbook project in order to insert the module. If the projects can all stay collapsed it would help...

Any ideas for code that triggers on VBA editor open?

[HansV]

Are you referring to the Project Explorer (see screenshot)?

S0731.png

[Rudi]

Yes

[HansV]

The free add-in MZ-Tools 3.0 has 'Collapse Projects' among its features:

S0732.png

See the first reply in VBE How to collapse worksheets by default for an example of the code needed to collapse projects.

[Rudi]

TX.
I'll give MZ-Tools a go again. I had it in the past and since I upgraded to Office 2013 some while back, I have never re-installed it.
Cheers