prevent viewing procedure names with ALT-F8

[grt]

hi,
I have a rather large database with a substantial amount of Procedures. As
my code became hard to read I decided to split it up in different Modules.
However, I can't use the 'Private Sub Statements' anymore while executing
code from different modules together.
Is there another way to avoid that you can see all the procedure names with
ALT-F8 now I can not use the 'Private Sub' names for my Procedures'?
tia,
grt

 

[JE McGimpsey]

hi,
I have a rather large database with a substantial amount of Procedures. As
my code became hard to read I decided to split it up in different Modules.
However, I can't use the 'Private Sub Statements' anymore while executing
code from different modules together.
Is there another way to avoid that you can see all the procedure names with
ALT-F8 now I can not use the 'Private Sub' names for my Procedures'?
tia,
grt

One way is to include an optional dummy argument in the procedure
declaration:

Public Sub foo(optional bar as long)
'your code here
End Sub

Note that this won't affect any of your existing procedure calls.