Modules in VBAProject (PERSONAL.xls)
 

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?

Modules in VBAProject (PERSONAL.xls)
 

"Drahos" wrote in message
...
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.