Protect Excel VB macro
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? -- baron5805 ------------------------------------------------------------------------ baron5805's Profile: http://www.excelforum.com/member.php...o&userid=28482 View this thread: http://www.excelforum.com/showthread...hreadid=480967 |
Protect Excel VB macro
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 ToolsProtection, 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 ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=480967 |
Protect Excel VB macro
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 ToolsProtection, 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 -- swatsp0 ----------------------------------------------------------------------- swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510 View this thread: http://www.excelforum.com/showthread.php?threadid=48096 |
All times are GMT +1. The time now is 08:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com