Excel 2007 passwords

Did you ever have that sort of day when you get asked how to do something techy and you just know that you’ve done it but because you do it so rarely you’ve forgotten how to do it?

To be honest I have those sorts of days all the time – especially with stuff I teach about once a year. It’s one of the reasons I have this blog: to write this sort of stuff down when I remember how to do it so that I can look it up next time I need to do it!


Today it was password protecting an Excel 2007 sheet. I was darned if I could remember how to do it – but I knew I’d taught Year 13 how to do it just before Christmas last year. And that it was similar to how it works in Access as well.

Here’s the solution:

Button > Save As > Tools > General Options

(Mac 2011: File > Save As > Options)

The tools bit is important – you need to click the button. Otherwise it won’t work.

You can protect the whole worksheet this way – to stop it even from being opened. You can protect them in different ways off of the Review menu, but this is better and easier. And it also let’s you get rid of annoying password protected sheets that other people have given you. Which is what we used it for today.

So – if you see me reading this in lesson time then you know that I’ve forgotten how to do it again, but that I am at least sensible enough to write it down so I can find it.


Summer’s here and the time is right…

…for thinking about Unit 10 exam work (not as much fun as Racing in the Street I’m sure, but, frankly, more legal).

What you could do, perhaps, over the summer is:

  1. have a think about a client you can make a spreadsheet for. Things like invoices or quote systems work well, rather like the Trumpton Times;
  2. maybe work though any of the Trumpton Times bits that you need to. These really do teach you all the advanced spreadsheet skills that you need to know about. Just remember that some of the functions are found in different places!
  3. take a check of the advanced skills checklist (which you’ll find over on That Blue Square Thing of course) and make sure you’re happy doing most of these (elements such as error checking might be best left until next term)
  4. have some fun and relax. Maybe try something new. I’m thinking of catching a concert at Snape myself…

This sort of thing will get you in the right place to really kick things off excellently in September. Promise.

Here’s a hint or two if you’re working at home:

  • to get the Developer toolbar click the Windows button > Excel options and select it
  • to get macros working click the Windows button > Excel Options > Trust Center > Macro settings > allow all (go on, you know you want to…)
  • the form controls are on the Developer tab on the Insert button (and don’t use the Active X controls because they work differently it appears)
  • controls to align things are on the Page Layout tab
  • the Name Manager is on the Formulas tab

Feel free to e-mail me if there’s stuff that’s confusing or not working right. I’ll see if I can get around to putting the Trumpton videos up on the web, I’ll see.

Talking of which, here’s Trumpton…