Quizzes & Puzzles5 mins ago
How to protect a'sheet' in Excel 2007
6 Answers
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
Is this impossible or should I try another prog?
Cheers for any help
Answers
Best Answer
No best answer has yet been selected by Grandpappy. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.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!
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!
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
If you are using Excel 2010 you can look here
http://office.microso...-HA010354324.aspx#BM2
Try this one for 2007
http://office.microso...P010078580.aspx?CTT=1
http://office.microso...P010078580.aspx?CTT=1
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.