My classes with a lock

[Martyh]

I want to package my classes, but I want to put a lock on them before I do so. I want the computer to return a message similar to one in the Word file attached. Can anybody point me in the right direction? There doesn’t seem to be a lot of help in this regard.

 

[boblarson]

That type of protection isn't all that it is cracked up to be (easily cracked). But if you want it, you just go to the VBA window, right click on your project, select PROPERTIES and then select the Protection tab and enter a password and check the LOCK PROJECT FOR VIEWING box.

A better way is to compile to an MDE (or ACCDE if on 2007) file.

 

[Martyh]

Bob thanks for the answer.

The classes are meant to help some one simply their own coding. Therefore I would need something that would lock just the classes that I have made while still leaving the rest. My understanding is that the mde would compile the whole works. Is that correct?

Could you have 2 projects for 1 mdb file? Then I could allow 1 project to be locked (mine) and then the other to be open to everyone.

Thanks again,

Marty Habicht

 

[boblarson]

You can create an mde file of your own and then add a reference to it in the references which would allow them to use the features you have set as Public in the classes.