The only way to hide VBA code is to password protect the project.
In order to insert a module, the project cannot be protected.
Hence, no way to hide the code.
If you automat the process, the user will not have chance to view it.
However, the only way to unprotect a project is manually or using SendKeys.

I have seen methods of turning the code in apparent gibberish, but still
runs as intended. Can't remember the name/product now, but will let you
know.

If you code is that important and secret, you should find a better update
method and/or not use Excel.

NickHK

"tf" wrote in message
...
Can I allow someone to import a module, but have it password protected
upon
importing so that they are not able to see the code? If not, is there
anything else I could do to avoid the code from being viewed?

Thanks