Monday, 27 July 2009

Excel password "protected"? Not really.

Just got a new template for my monthly activity report made in Excel (this is version 11 or something like that). The administrator who creates / changes the templates will not give up the idea that she have to password protect certain parts of the sheet. This means I should not be able to have it auto filled with the normality just by adding my own formulas for it. IE, I'd like the activity report to, by default, be filled out with the normal hours I am doing. I only want to have to fill in any deviation from that. So if I have a day off for vacation, I should just have to fill that out, and the cell with my normal working activity should then show nothing, If I have half a day off, the other half should show up as the normal default activity. This is rather simple in to achieve in Excel as you might know. But only if you are allowed to change things. ;-)

So what to do? Well, since Excel comes with VBA a small simple script can sort this out for you.
(Here I had an example script published, but realised it might not be such a good idea to do so. So I removed it again. Ooops!)
It is a matter of minutes to crack most passwords with just a bit of VBA code. That is a bit crap IMHO. A lot of people probably think their spread sheets are fairly secure with a password...

0 answers back: