VBA and Modules

[mdolinger]

I have my personal workbook that I've stored all my macros in. There are 25 different modules. My question is should I worry about that? Should I clean them up and put them together or does it really matter? What is the best practice going forward with macros and the modules?

Thanks in advance

[Keebellah]

Hi, I don't think it's a problem but what I would do is group the same type of macro's/functions in the same modules and give the modules descriptive names.
I only have a small number of macros in my Personal macro workbook and have alse preceded the macro names with gp_ (g p and underscore), the reason is that sometime I copy the macro or even the module to a xlsm file and then remove the gp_ for use in that file so I alwasy know that Y run the correct macro.
BTW GP stands for General Purpose.
Hope this makes sense
Above all don't forget to backup the Personal macro book