Sub = Public Sub
Private Sub makes it available to other macros in the same module, but not to the user
To do what you want put (Hopes this doesn't confuse you even more)
Option Private Module
at the top.
But remember, the user won't see the macro in the macro list, but if they write the macro's name, they'll be able to execute it.