How to protect a'sheet' in Excel 2007

[Grandpappy]

Using 'Word' you can password a file and even though you can see it you can't open it without the password,well, how do I achieve the same effect when using Excel and just want to protect a single sheet(not the whole workbook or anything)so that it's visible but clicking on it asks for a password,as in Word?
Is this impossible or should I try another prog?
Cheers for any help

[ChuckFickens]

You can't protect a single sheet in a workbook so it can't be seen AFAIK.

You can protect the entire workbook so it needs a password to open it, or you can protect a worksheet so it can't be changed but I am pretty sure you can't stop a single sheet from being viewed once the whole lot is opened.

[johne1892]

Hi, what version of Excel are you using?

[MichaelZZ]

I'm not sure if it's the same in Excel but if I was trying to do something similar in the spreadsheet programs that I'm familiar with (Lotus 1-2-3 and Open Office Calc) I would change the font colour of the text that I want to hide to the same as the background. (Usually white).
Then the only clue that there is something hidden there is the coloured line under the capital A in the toolbar. You can of course hide the toolbar if required.
Not a "Password Protection" but just a little bit of a secret that wouldn't be instantly obvious!

[johne1892]

You can easily protect worksheets or part of them so that the text can't be amended so if you tied that in to Michael's answer would be OK.

If you are using Excel 2010 you can look here
http://office.microso...-HA010354324.aspx#BM2

[johne1892]

how dumb am I....you have Excel 2007 in the question....sorry....

[johne1892]

Try this one for 2007
http://office.microso...P010078580.aspx?CTT=1