View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] par_60056@hotmail.com is offline
external usenet poster
 
Posts: 42
Default Sub () that does NOT appear in Macro selection

On Jul 13, 11:46 am, Mike wrote:
Private Sub yourMacroNmae()

"J@Y" wrote:
Is there a way to have a Sub () not appear in the macro selection (alt f9) ?



If a sub has a parameter then it won't appear.

private sub yourMacroName(dummy as object)

Just pass in a 0

Peter