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...

Move minus two days

The house move is closing in! Only two more days to go before the big move is going to happen.
This weekend has been spent mainly on packing stuff. We have almost run out of boxes now. The garage and the kitchen is packed, and almost everything else we don't need during the next two days. Only thing left is the loft, which we will tackle this evening. And a few other smaller bits 'n' pieces...
Oh, we actually managed to do some fun stuff as well during the weekend. The usual karate session on Saturday morning was a good one, even though it was on the tougher side, even for a session with Sensei Tony (no, not me silly, our instructor). Today it is Monday and my legs are still in pain.
On Saturday evening we went to the pictures. We saw the latest movie about him that there boy of a Potter. Not bad at all, I'd say! It came as a surprise for Clare that one of the lead characters died at the end though, since she hasn't read any of the books. I don't know if it just me, but it felt like the movie was not as dark as the book, when it comes to all the evil stuff that went on in the world of wizardry and magic?