Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Phil Sanchez   on Jan 25 In MS Office Category.

  
Question Answered By: Birke Fischer   on Jan 25

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.

Share: 

 

This Question has 20 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Removing the VBA SourceCode from the Workbook Or get search suggestion and latest updates.


Tagged: