Hide code in macro add in

[Kprogrammer]

while sending file containing macro , it has all macro codes in it.

so can i create add in for this so that code will be hidden but it will execute?

Thanks in advance.

[Zizi64]

viewtopic.php?f=20&t=8043

You can not protect the predefined Standard library by password, but you can protect all of other (user defined) ones.
But only the Standard library will be loaded into the memory when you open a document. You must load-in all of other Libraries by your macro code.

[Villeroy]

But only the Standard library will be loaded into the memory when you open a document. You must load-in all of other Libraries by your macro code.

No. Any library that is called by some script-URL (button, shortcut, menu, event) will be loaded automatically. If you need to call routines from a second library, then you need to load this library programmatically.

[Zizi64]

No. Any library that is called by some script-URL (button, shortcut, menu, event) will be loaded automatically. If you need to call routines from a second library, then you need to load this library programmatically.

Thanks, it is a useful (and new) information for me.