Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How with VBA, can I activate one of many modules in a VBAProject? | Excel Discussion (Misc queries) | |||
Public, Private, Event modules, Forms modules,,, | Excel Programming | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
When to code in sheet or userform modules and when to use modules | Excel Programming |