Hide macro List from Alt+F8 window.
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
|