Protecting the code using code

[Jzz]

Hi all,

I have a problem protecting my VBA project. I want to be able to
protect the code from viewing, using code.
This is unusual, I know, but I want to be able to freely send the
workbook via E-mail. The anti-virus software on our mail server does
not accept the workbook to be sent when the code is locked, but I do
not want the users on the other end of the line to be able to view and
change the code, as this happened before.
The idea is that the user has to 'activate' the workbook with a
button, which runs a code that protects the workbook and the code. The
workbook is not the problem, but is it possible to do the same with
the project?

I hope somebody has a suggestion. Can't find anything in the help...

Greetz,

Jzz

 

[JNW]

Does the antivirus software allow .zip files?

 

[Jzz]

Didn't think of that, good idea!

I'm not sure it does, but it's worth a try!

Jzz

 

[JNW]

Even if it doesn't allow zips you can do the following.

1-Zip the file
2-rename the file and put "remove" after the .zip (i.e. filename.zipremove)
3-email that file and instruct the user to copy to desktop then rename and
remove "remove" then unzip.

 

[Jzz]

Yeah, well, I think my users are not really capable of that ...

But I think the normal zipping is actually the best trick. It has to
be sent to a ship using sattelite uplink, this is quite expensive.
zipping will safe some costs as well.

Thanks!

Jzz