Adding a parameter to your sub will keep it from being listed in the Macro
window when the user selects Tools >> Macro >> Macros. You don't have to use the
parameter for anything; you just have to include it in the sub declaration and
pass it a suitable value when you call it.

Public Sub test(AnyArg As Variant)
'your code
End Sub

To call it:
Call test(x)