Recall another Sub

**Elvisman** · 09-01-2010, 03:44 AM

Hello,

for preventing unnecessary repetition in a Sub I would like to make a method (or Sub I don't know how to call it but you know what I mean) outside of the sub that can be recalled from the first Sub. So for that I have two questions:
1. What code could I use for activating another Sub within the first Sub?
2. Is it better to make the 'other' Sub public?

I'm hoping someone could help me again with this one. Because of this forum now I'm almost ready writing an application for Tray Selection..

Regards

Jeroen

**Alf** · 09-01-2010, 03:50 AM

Would this be of help?

Sub RunAllMacros()
Macro1
Macro2
End Sub

**ajaykgarg** · 09-01-2010, 04:18 AM

1. What code could I use for activating another Sub within the first Sub?

Call Sub2

2. Is it better to make the 'other' Sub public?

If the other sub is in same module, you do not need to make it public. Else, you will have to.

hth
Ajay

**romperstomper** · 09-01-2010, 05:30 AM

As regards scope (qu. 2):
If you make the sub Public (the default), it is visible to all other subs in your workbook and to the macros dialog (unless the sub takes arguments); if you make it private, it is visible only to routines in the same module, and not to the macros dialog. If you add:

Option Private module

to your module then the macros are not visible to the macros dialog, but the two rules above apply as regards visibility to other code in your workbook.
Note: regardless of scope, all macros can be accessed from the macros dialog if you know the name of them (even if you can't successfully run them).
The same basic rules apply to functions, but substitute the function wizard for the macros dialog.