Hi Shane,
I know I can protect the module but it's to easy to bypass it. It's a
rather unique application specific to my industry so I know for sure no one
else has done anything like it.

I think if I do sell it, it will be on a fee basis per month or quarter.
The main purpose of pulling comments out and radomly changing procedure names
is to make it impossible to figure out how it verifies if it's a valid copy.
If I didn't at least do that, someone could easily bypass VBA protection and
figure out how to bypass the security.

I was thinking if I had something to change all the procedure names to
something like: cccccccccc,ccccccccccc,cccccccccccc,ccccccccccccc, a normal
person would never be able to figure out it... each of the above strings
could represent a procedure but since they all look so much alike, it would
be difficult trace and see where the copy protection scheme actually takes
place.

I'm sure someone could figure it out but without any comments and all the
procedures named like the above set, it would certainly keep all but the most
determined out.

I saw a couple other replys that had some ideas so if I choose to pursue
this, it sounds like it's at least doable.

Thanks,
MikeZz

"ShaneDevenshire" wrote:

Hi,

Why not just protect the module? In the VBE Tools, VBA Project Properties,
Protection... If you are going to sell an application, make sure it's not
already out their for free. Of course there are Excel programmers who sell
there code even though other programmers offer the same routines for free.

--
Thanks,
Shane Devenshire


"MikeZz" wrote:

Hi,
I have an excel VBA application that I'm considering to sell at some point.

As a deterant to any unauthorized usage, I was wondering if it's possible
through VBA to completely remove all comments and rename all the routines and
functions in all modules and forms with unrecogizable names so that the code
would work yet be vertutally impossible to understand.

Thanks for any help!
MikeZz