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

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

Thanks, that's what I thought. Really, it's not that the code is a secret -
it's just that I didn't want others to try to change it and create a mess of
their systems. I just wanted to minimize accidents if at all possible. There
are about 20 systems this code needs to be imported into and it's an excel
based program. We have updates for each program that are tedious and time
consuming, so this code will make everything updatable in a matter of seconds
once imported.

Thanks again -

"NickHK" wrote:

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

Just thought of something. I can create it as an add-in. They can then save
the password protected file to their hard drive and everybody's up and
running.

"tf" wrote:

Thanks, that's what I thought. Really, it's not that the code is a secret -
it's just that I didn't want others to try to change it and create a mess of
their systems. I just wanted to minimize accidents if at all possible. There
are about 20 systems this code needs to be imported into and it's an excel
based program. We have updates for each program that are tedious and time
consuming, so this code will make everything updatable in a matter of seconds
once imported.

Thanks again -

"NickHK" wrote:

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