Modules- what to do with blank ones

[johnnywinter]

A newbie question. I have learned advanced Excel and VBA quickly thanks to board members here, so I now have a gret Workbook, but need to clean up my work so I can distribute it.

I have 15 modules, but only VBA code in 4 of them.

1) Should I copy paste all my subs into 1 module?
2) Can I delete all of the empty modules?
3) what did I do to get all the blank modules?

Any links or explanations of where to go from here? Meaning what is and how to use a VBA Project; how to protect VBA code, how to protect a Project.

Thanks,

[royUK]

1. You needn't move them unless you want to
2. You can delete empty modules and should do so. Right click & delete.
3. You add modules by clicking insert & selecting module, or by recording a macro.

[johnnywinter]

RoyUK,

I eliminated all the blank modules.

Do I gain anything by having all the Subs in one module (speed, security, less chance to be corrupted, etc)

[shg]

It depends on the complexity of your spreadsheet.

I like the arrangement suggested by Stephen Bullen et al in Professional Excel Development:

• MEntry: Procedures called from toolbar buttons
• MGlobals: Definitions of all public constants and variables
• MOpenClose: Code required to open and close the application (called by Open and BeforeClose events)
• MStandardCode: Code reused without modification from other applications
• MSystemCode: One or more modules that implement application-specific processing
• MUtilitities: Code used solely in development and maintenance of the the application

That may be way more than you need for now, but think about separating code into functional groups.