protected
Who hasn’t ever had the need to crack open a worksheet to see whats really going on?
Who hasn’t genuinely forgotten a password and needed to edit a sheet? or really taken over from someone who left after protecting loads of sheets with an unknown password?
All of those have happened to me, but the big one is I regularly get sent workbooks to review for some kind of repair/enhancement. Its impossible to follow the logical flow through protected worksheets, the auditing toolbar doesn’t work, select special doesn’t work, apparently blank cells may have hidden contents…
I guess a few of you know I’m not a fan of worksheet protection, so it will come as no surprise that I use the services of a password removal tool. There’s plenty of free VBA floating around t’interweb that will brute force a password. And some 2 line instant hacks for older versions. Some I tested do not remove all passwords – thats a PITA, after waiting 2 minutes.
VBA was too slow, so I went to a VB6 COM addin – for about a zero % speed up sadly. It still takes upto a couple of minutes on my laptop. Not good enough for a busy boy like me.
So I wrote an xll version which removes passwords in about 1 second on the same laptop. Its compatible with, and has been tested on, every (Windows) Excel from 97 to 2007.
Winter is coming
As winter is coming (did it ever leave) and the smurflings need new shoes this is another commercial product. There is a free trial, and the full version only costs 20 quid (+HMRC cut of course) so its not like its going to bankrupt any other busy people who can’t wait 2 mins for a VBA version. Get in touch for details of multiple user discounts.
This only removes worksheet passwords and workbook structure ones, its doesn’t open or un-encrypt files saved with a password. If you can’t get into the workbook this tool won’t help.
All the details are here
The shop page is here
More on Excel security here
Its a proper commercial product so comes with full support, and you can buy in confidence knowing you are not funding drug cartels or people traffickers.
If anyone would like to incorporate a no user interface version into their products then give me a shout about possible licencing deals. I have already had some interest from some audit tool vendors, and you can be sure this will find its way into the next version of XLAnalyst (due out before Christmas (2008!))
Any feedback welcome, here or via email.
cheers
Simon
You must be logged in to post a comment.