how to protect vba code in excel

[mouzi4us]

Hi frnds I m new to excel Vba codesI ve designed a userform for myself and wrote some codes and events for itI used Vba properties to protect it with password ,but I saw an article which there was a code that easily could crack my excel 2013 vba password !!!I'm wondering if is there any way that we could protect our file codes from others to crack it so easily like this ??

[p45cal]

cross posted in at least 2 other places.

[Aussiebear]

Firstly, may I say that I'm disappointed in your habit of cross posting the same issue on a number of forums. Secondly, sadly the answer to your thread is "No". Excel has never been secure, and given the number of releases, I don't think Microsoft has a solution to the problem.

[SamT]

Use very complex passwords to make it a little harder and maybe the Crackers will give up

MyPassword:="@F4%*>D8?@%(<%*G +/:...B9*#_2+AA*>{_%*@&"

Hint: Use no Alpha Characters except A to F and no more than 2 numerals in a row. (12 but not 123) and no more than two Alphas in a Row (AB but not ABC)

[krishnak]

Wow, how do you ever remember the password?

[p45cal]

He uses the same one all the time, including banking. :devil2:

[Aussiebear]

He uses the same one all the time, including banking. :devil2:

ROFl..... :old: well it comes with age.

[SamT]

I had it tattooed on the back of my hand :D

In Sanskrit, so no one else could read it.

[Paul_Hossler]

http://cpap.com.br/orlando/XLtoExeMore.asp?IdC=OrlMoreWin2

I think that this can make an XLSM into a encrypted file (not just protected) that requires a special executable to unencrypt it in memory

Making the exe files would most likely have a much harder to crack password

[Jan Karel Pieterse]

Have a look at this tool: http://www.spreadsheet1.com/unviewable-vba-project-app-for-excel.html works a treat.

[Aussiebear]

G'day JKP, had a quick read of the info at the site you kindly linked to, but remain somewhat disallusioned. There seemed to be exceptions for most normal expected behaviours. When you suggest it works treat, can I assume you yourself are currently using the software with great success?

[Aflatoon]

Use very complex passwords to make it a little harder

FYI, this doesn't actually make any difference to breaking through VBA security.

[Jan Karel Pieterse]

My RefTreeAnalyser has the protection implemented. www.jkp-ads.com/reftreeanalyser.asp (http://www.jkp-ads.com/reftreeanalyser.asp)