I am currently working on a project using xL 2k. This project is going to be a widespread distribution for use on old machines running xL 5.0. I am trying to lock access to the VBA source code. When I pw protect the module and then save the .xls as 95/5.0 xls it seems to always remove the module's protection.

This file will be handed off via other users that have a newer version of xL who then are able to open the VB editor and browse my code as they see fit. Is there a workaround for this?

As an alternative to locking the module, is there a way to lock worksheets using VBA with a password without making the password visible in the code?

This project is time sensitive and I am at the end of this phase of development. It needs to go out tonight!! PLEASE HELP!