Protect my code ? [Resolved]

[VB4fun]

Now that I have gone to all this work....

In VBA, is there a way to secure the code so someone cant get to it..?

I have protected the worksheets, etc. but I want to keep the users from getting to the code....

is this possible ?

[M Owen]

compile the database.

[VB4fun]

After looking at my post, I wasnt clear..

I am working in Excel. While I tried the compile, it did not seem to do much (not like VB anyway).

But I did go into Project Properties, and clicked on the Protection tab, which allowed me to set passwords. While this isnt exactly what I was looking for, it will help me accomplish what I wanted.

Thanks for the post, you definately helped !

[Eras3r]

well, he meant compile the database into a .mde file (by doing this, your code is no longer in the db..... its actually compiled)

[VB4fun]

At the risk of sounding like a complete idiot here, I have to ask a question.

I have tried using the compile feature, within VBA, within the Project IDE. And it doesnt seem to do much. When I open the worksheet and go to Tools, Macro, Visual Basic Editor, I can still get to the code (when I remove the password mentioned above.)

I dont seem to find a file, related to my project, which the XLS spreadsheet was compiled into.

You mention the "db" in your comment....

We are talking Excel here, and not Access....correct?

Or am I just not following what you guys are suggesting...?

[Ephesians]

The guys are talking about Access and you are correct, in Access compiling the database into an MDE will remove the code accessibility. In excel the only way to protect your code is really to put a password on the module.. but Lord help you if you forget what it is..