Sorry. You're confusing my intent because I said variable instead of
parameter (to be passed).
I know what Variant variables/parameters are.
What I meant was that I didn't follow the discussion as far as
which type(s) of parameters, which, when put in the Sub parameter list
, will cause the macro to NOT appear in the macro menu list.
It would make sense that a macro will not appear in the macro menu
if it requires input parameters because there is no way to pass
parameters from the menu, therefore it must be an 'internal' sub.
However, the discussion about Variant parameters lost me as far as
whether/when they cause the macro to be seen / not seen in the menu list.
Perhaps I don't need to understand this.
Idea:
If I could make it so that (input) parameters are required in all
macros (some will be dummys), then (if the above is true) no macros
would appear in the menu list. This may be an idea, but this is not
critical. I just want to hide my code from others. It's just a "you
can have my sheet and use it for free, but you can't see my code" sort
of thing.
I was hoping that since it is compiled code, the source could be
blown away after compiling it and VBA would just use the compiled
version of the code.