View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_2360_] Rick Rothstein \(MVP - VB\)[_2360_] is offline
external usenet poster
 
Posts: 1
Default 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