Protecting VBA script (self destruct?)

Hello community,

I am very concerned that my excel and outlook VBA password can be hacked in about a minute just by changing DPB key with notepad. How can I add another layer of a security?

Any chance to create a startup script like

Please Login or Register  to view this content.

and check for a valid DPB key and if not found then maybe re-protect the file with a new password or somehow self destruct the source file by making it corrupt? We are talking about xlsm excel files and the outlook VbaProject.OTM file.

Keeping the file in working condition is not a concern, I always have the original copy.

Thanks in advance!

I agree that protecting vba with vba is certainly not very secure, but on other hand most people wont be able to make a next step if changing the DPB key fails. So if the method well distributed on the net fails, they just wont be able to use my code and thats my goal.

BTW is there an easy way to convert VBA projects to exe? Because I guess I could add all my forms and scripts into a separate exe and then control outlook as I did many scripts controlling outlook from excel. <<< could be a stupid question.

What I am saying is do we have an IDE where I can create the same forms and scripts and control outlook from a compiled exe?

Alright, I will try Visual Studio... I guess creating forms and stuff should be easy with that, hopefully I can reproduce everything in that environment.

Thanks for sharing your thoughts.