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?
Code to collapse Projects in VBA Project window
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Code to collapse Projects in VBA Project window
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Code to collapse Projects in VBA Project window
Are you referring to the Project Explorer (see screenshot)?
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Code to collapse Projects in VBA Project window
Yes
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Code to collapse Projects in VBA Project window
The free add-in MZ-Tools 3.0 has 'Collapse Projects' among its features:
See the first reply in VBE How to collapse worksheets by default for an example of the code needed to collapse projects.
See the first reply in VBE How to collapse worksheets by default for an example of the code needed to collapse projects.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Code to collapse Projects in VBA Project window
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
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
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.