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.
|