Protecting the code using code

J

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
 
J

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top