"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