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: Mohammed Evans   on Jan 25

Must'a been one of those realistic dreams one sometimes has.

So, from the comments, I understand that the Macro names will be
visible in 'the menu' even if password-ed unless:

They are functions.
They declare variables - sometines [I couldn't follow the thread to
fully understand the limits of this phenomenon]

I hadn't thought about the Macro list, but that's not too important as
long as the code  itself is difficult to get to (I have a few of the
password cracking macros). If I want to be more secretive, I can
Find/Replace all names with cryptc names before "publishing".

Dave - FYI:
Your "must pass vars to subs" comment is correct in the first
level. However... You could have a sub which gets data from sheets
and replaces it there..sort of "sucking parameters into" a sub rather
than "passing to". But, then again, I'm the guy who uses
predominantly globals. (;-(


And I'm now working on my File read/Write code and it is coming  along
just fine thanks to comments and examples on the group.

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: