In Excel VBA (2003), I've noticed that any Public or Friend Sub method in either a module or ThisWorkbook that doesn't have any arguments will show up as a Macro that can be run by the user. I.e. when the user goes to Tools –> Macro –> Macros… (or Alt+F8) the method will show up in the list that can be run.
For sanity's sake (organization, maintenance, etc) I do need to separate the code into modules. I'm hoping to find a non-hacky way to hide some methods from the user, but still allow them to be visible to other code modules. Note that all the code is contained within the same application, so no external code is called.
My current work-around is to use Functions that return a boolean instead of Subs, and just ignore the return value. eJames suggested the option of using an optional argument in the Sub, which will also hide the method from the list of macros.
Neither of these feel quite right, however, so any advice about how to structure a non-trivial Excel VBA application would be much appreciated.
Best Answer
Add the following to the top of your module:
From MSDN: