Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel macro protect problem | Excel Discussion (Misc queries) | |||
How to protect my macro | Excel Discussion (Misc queries) | |||
How to password protect several excel workbook pages using a macro | Excel Programming | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
protect - macro? | Excel Programming |