I sent a locked spreadsheet to a friend in USA and he returned it in less than a minute with password details. So there is software around. Before that I had paid $10 for a cracker that tries all permutations, it would take 100's of years for a long password, so don't go there...
Good afternoon Racing Ka
Download and install my add-in via the link below.
Once installed go to Ultimate > Protection > Remove Protection.
Should take less than a minute, it's free and the help file explains exactly how it works!
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
I had the same problem and this add-in is sweet. Thanks man!
Last edited by wmorrison49; 11-15-2007 at 11:12 AM.
hi,
what happens if the worksheet is protected and was to stay protected could this add in let the user in
does this also apply to the macros that are protected
steve
Hi stevekirk
The add-in removes worksheet / workbook protection due to a substantial weakness in the protection routine, the knowledge of which has been in the public domain since Excel 97, but Microsoft chose not to address until Excel 2007. Microsoft's line is that the protection is there not to stop people changing the spreadsheet without authorisation, but to stop accidental erasure of formulae.
Macro protection is a little trickier but can be still be removed relatively quickly (my tool of choice for this is a hex editor), and the protection whereby a password is required to open Excel is trickier still - but not impossible. Just type "Excel password cracker" into Google to see...
DominicB
I just tried to use the remove protection command again and I can't get it to work anymore. Is there a trick that I unknowingly did the first time? Any little quirks that you have to do or the order of anything? The box that has Close/Start isn't popping up anymore.
Hi wmorrison49
No quirks or anything tricky. I've never come across this or had it reported as an issue. Usual kind of advice applies - restart Excel and try running it. If this doesn't do the trick try reinstalling from the setup file and making sure that the add-in is invoked properly.Any little quirks that you have to do or the order of anything?
HTH
DominicB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks