5 different procedures 10 private subs

[alexanderd]

i have 5 different procedures each procedure runs as a stand alone but all have one thing in common, they use the same 10 private modules.
how or where can i place the private modules so that i can call them from the different procedures. is it possible and if so how can i achieve this

 

[TonyJollans]

Hi alexanderd,

If your Subs are Private, they can only be called from inside the same Code Module. If your 'Procedures' are in a different Module, you will need to make the Subs Public. Always assuming everything is in the same Workbook (or Document if it's Word), the only other possible problem is if any of the Subs are in a Class Module (or a UserForm) they may need to be qualified with the Class (or UserForm).

If that isn't enough then can you post back with more detail.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.