"Rick Rothstein (MVP - VB)" wrote in
message ...
3. Add an argument to the sub. Change
Sub MyStuff()
to
Sub Mystuff(byval x as long)
Note that using this method requires you to supply a value for x any
time
the sub is called.

If you declare MyStuff as a function with no arguments, you can still call
it like a subroutine and it won't appear in the Macro listing...

Function MyStuff()
' Do your subroutine type stuff here
End Function

Rick

Ah but then it'd show up in the function list !

Regards,
Peter T