Subs in Macro list

[scott_hanebutt]

I have created a module that has several subs in it. I only directly run 1
sub. All of the others are run as a result of that sub. The problem is that
when I choose what sub to run all of the subs show as options. I only want
the single controlling sub to be listed.

Thanks,
Scott Hanebutt

 

[Jan De Messemaeker]

Hi,

Two possibilities (there may be more but these I happen to know)
- Code as Private Sub instead of Sub
- Call them as functions rather than procedures (which I mostly do)

HTH

 

[scott_hanebutt]

Thanks, that was exactly what I needed. I decided to use private subs
instead of functions because I was not returning anything.

Thanks,
Scott Hanebutt