VBA Editor - Collapse by Default?

[cr731]

In the Excel VBA editor window, is there a way to have it open with all projects collapsed by default?

Every time I open the window to edit a macro, my Personal XLSB file shows fully expanded, which I don’t like because it takes up space and I have to manually collapse it to see the other projects I’m working on.



Can this be changed or if I save the file collapsed should it reopen collapsed?

Thanks

Edit: It seems that it doesn't open expanded 100% of the time - but I can't determine what action causes it to open collapsed versus expanded. This also applies to any other workbook with macros - sometimes when I open the editor window, the project appears expanded down to the Module level, and other times, it's collapsed. Just wondering if there is a reason for this?

 

[mrmmickle1]

Maybe try looking at this thread on stack overflow:

https://stackoverflow.com/questions/16977441/vbe-how-to-collapse-worksheets-by-default

There look to be several solutions, including a full blown application called MZ-Tools.

https://www.mztools.com/index.aspx