View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_14_] Bob Phillips[_14_] is offline
external usenet poster
 
Posts: 216
Default 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.