Modules in VBAProject (PERSONAL.xls)

[Drahos]

Hi All,
I would like to ask a question. Looking to to the Modules in
my PERSONAL.xls I see a lot of them. Something about 60. Looking into these
Modules I see almost all of them are empty. I suppose they were created on
the base of macro recording etc. Is it possible to remove all empty Modules?
I
suppose there should be the same number of Modules as I have the number of
macros in my PERSONAL.xls (listed in the list of macros). If possible to
delete them will they be automatically renumerated? I mean from Module1 to
Module15 for example. Is it possible to set up the Excel/VBA to delete
automatically an empty module?

 

[Bob Phillips]

Hi All,
I would like to ask a question. Looking to to the Modules in
my PERSONAL.xls I see a lot of them. Something about 60. Looking into these
Modules I see almost all of them are empty. I suppose they were created on
the base of macro recording etc. Is it possible to remove all empty

Modules?


Yes, no problem.

I
suppose there should be the same number of Modules as I have the number of
macros in my PERSONAL.xls (listed in the list of macros). If possible to
delete them will they be automatically renumerated? I mean from Module1 to
Module15 for example. Is it possible to set up the Excel/VBA to delete
automatically an empty module?

No, nothing automatic. You can cut and paste them from one module to another
then delete the empty ones.