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

 

[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, n
it is not secure from anyone with a slight desire to figure out how t
break the code. Also, it really doesn't matter how many alpha/numeri
characters you place in your password, Excel breaks it into its ow
code, which is why it is so easy to break.

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

This password is encrypted and is NOT easily broken.

Good Luc