Managing large personal.xlsb file

[macfuller]

I've got 20 years of utilities, forms, classes, and other macros in my personal.xlsb file. It's over 1MB now and while I use some macros more than others I don't want to leave any out for when I need them.

I know it's a big chunk of memory to load the file, even if particular modules aren't loaded until they're used. But if I have a bunch of forms that use the same utility that resides in a huge modUtilities.bas module, the whole thing gets loaded. I haven't gone to the effort of extracting most-used utilities into a separate and smaller module (yet). There's a lot more RAM in a common PC than there was 20 years ago!

So I'm wondering how other people handle this situation. Copy common utilities into forms so that only the form module loads? Somehow have sub-personal files? Some other good governance practice?

Or have I opened the Excel equivalent discussion of which way to hang the toilet paper roll?

 

[Logit]

.

Or have I opened the Excel equivalent discussion of which way to hang the toilet paper roll?

Yes.

Based on my experience of having asked practically the same question. The results of my "survey" showed everyone is
doing something different - pretty much fits their own personality / needs.

Some have their collection as you have. Others, like myself, have my toolbox residing in a separate folder / separate workbooks or text files / each
named for what the code does.

There are a few online example projects that will categorize your code into a "dictionary" of sorts. Similar code on same sheet - with an INDEX designed with
hyperlinks for quick movement to the sheet in question. I've thought of either using someone else's design (that is free) or construct my own.

In the end ... 1mb is not a lot of memory to be burning. Although it might be a small inconvenience, don't continuously run your toolbox. Only
open it when it is needed ?