No such thing, they're easily cracked. Harder to break a worbook open and the VBE password, but it's all very insecure stuff. Sorry.
This is a discussion on Very good protection within the Excel Questions forums, part of the Question Forums category; I know how to protect a sheet/workbook. Unfortunately, there are hacking programs out there that can resolve a 12 character ...
I know how to protect a sheet/workbook. Unfortunately, there are hacking programs out there that can resolve a 12 character password in Excel....in a matter of seconds. I know, because I used it. A "friend" asked me if it was possible. It is, actually very easy. No, I didn't tell him the password. Told him it wasn't possible...
But of course it is, and since I write sheets for people, and just ask for a donation, I know that they're stolen. I know, old problem. I'm just tired of being stepped on after I spend a good deal of time on other people's problems. Obviously, MS's algorithym is easy to crack. I suspect (?!) VBA is the way to go. Can anyone point me to a script, or give me pointers on how to seriously "lockdown" an Excel workbook?
I'm interested in protecting my work, and the work of others. I was surprised to find out it was so easy to crack a password. My intentions are sincere, I will not share cracks, passwords, etc. with anyone violating a copyright, etc. I know how it goes.
As Nate said, & you know, security is weak. I like this:
protect sheet with "test" (no quotes)
unprotect with "zzyw" (no quote)
...for more on the algorithm, see:
Absent any decent built-in security, you need to do something else / add you own. Ole Erlandsen already has:
...though I'm not qualified to comment on how much "stronger" this is.
Of course, if one is willing to encrypt a file, an option to consider would be to zip the file (as in WinZip) with a password. And, no, I don't know anything about the qualities of their encryption/password algorithms.Originally Posted by PaddyD
OK, this probably isn't very advanced, and I'm certainly not a hacker, but I have some "curious" users who try to "break" what I do.
In my case, removing ALL of Excel's functionality (Command Bars, etc.), except what you want it to do, works. I use keyboard shortcuts to give it (functionality) back, but you may want to leave that out...
I believe that Nate did post something that checks Environment UserName. If it's not = to you or your specified user, then application.quit"s". I use that for an "update" file that I send out and it works, but "my users are complete nincompoops", so I have no worries. (YET!)
And as Nate said, if somone "really" wants in, they can. But then no program is truly safe is it? (but that's probably a "Back Orifice" question...Waaay beyond me...)
Too bad creeps like this are out there trying to figure out ways to FUBAR hard work instead of investing it in helping people! (But that's a different post & different forum...)
If I and the others who help out here were to take this attitude, the only way any one would ever get any help would be if they paid for it. Given a choice, I'd rather educate a nincompoops than f**k with their XL environment with software that is guaranteed to leave it screwed up sooner or later. When all is said and done, George Bernard Shaw's comment on reasonable and unreasonable men comes to mind.
Originally Posted by pennysaver