Modules - Save each code in seperate module? or group like code in

  • Thread starter Thread starter BEEJAY
  • Start date Start date
B

BEEJAY

Have approx. 75 modules in my Personal.xls file.
I have tried both ways - Combine like code into one module
and (currently) seperate module for each code.

1. What are pros and cons of each?
If I group my codes, I can get down to about 12 modules.
2. Will the auto saving of the Personal.xls be much faster that way?

However, If grouped, I find it a pain to have to scroll up and down so much,
while trying to find code that I want to use in another code set.

3. Is there a way to open TWO sheets of the same module?

Thanks for any input.
 
Packaging your subs and functions into modules can be helpful if you need to
export the subs in groups.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - VBA to get a list of Module names in the project 4
Breaking User Form Code into modules question 9
Code not saving in Class Module 3
Pass between modules 7
Adding Sub code in Function module 4
Close various modules/codes windows 5
How to execute a dynamically added or changed module 1
Delete a sheet and delete a module in Another Worksheet then save 4

Back
Top