Sub MyMacro(optional dummy = 1)

or

Private Sub MyMacro()

The macro can still be run through the tools menu choice, but won't be
listed.

--
Regards,
Tom Ogilvy


"cottage6" wrote in message
...
Is there a way to prevent running a macro through the Tools menu choice?
Thanks!