Just for interest, while of not much utility, you can run a sub like
Sub Tester3(sStr As String)
Debug.Print "tester3: " & sStr
End Sub

from the textbox of the Tools=Macro=Macros dialog by entering

'tester3 "Hello"'

and hitting enter or clicking the run button - but it isn't displayed in the
list.

Based on some other information on xl2002, this may not be possible there -
I haven't tested it in xl2002.

Regards,
Tom Ogilvy


Bob Phillips wrote in message
...
... also

If they have arguments, they will not show up in the list, as you cannot
pass an argument value in the list. And if they do repetitive tasks, it is
often the same task, but on different data, so there is a need to pass a
reference to the data to be acted upon.

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"Don Guillett" wrote in message
...
you could label them as private

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"verizon" wrote in message
...
Hello Board

I have read that good programmers create many subroutines when
programming
so that many macros can use repetitive routines. it also makes it
easier
to
track down problems. I concur.

Nonetheless it is distracting to have all of those subroutines show up
in
my
macro window. They are not independently executable and it requires
that
I
scroll through many unwanted macros to get to the ones that i want.

How do I prevent the macros which are only "useful subroutines" from
appearing in my macro window?

Thank you

W