Protect Excel VB macro

[baron5805]

Are VB macro passwords secure?

I have password protected my Excel macro, but there appear to be no end to the number of programs that will crack that password.

Does the complexity of the password affect these programs? If I were to make my password 20 characters long, comprised of alpha and numeric characters, would this prevent the password from being overridden?

If VB macro passwords are not secure, then what is the best way to protect your code?

[swatsp0p]

Are you protecting your VB code OR are you protecting the workbook? These are different things... and different levels of security.

If you simply protect your worksheet/workbook via Tools>Protection, no it is not secure from anyone with a slight desire to figure out how to break the code. Also, it really doesn't matter how many alpha/numeric characters you place in your password, Excel breaks it into its own code, which is why it is so easy to break.

VBA protection, on the other hand, accessed through the VBA editor by right clicking on the project you want to protect and choosing 'VBAProject Properties'>Protection tab.

This password is encrypted and is NOT easily broken.

Good Luck