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.