Protect just one worksheet of an excel doc?

[Guest]

I have a large excel document, and one of the worksheets within the document
is very confidential. Is there a way to password protect just that one
worksheet within the document?

 

[Peo Sjoblom]

It depends on how confidential it is, all workbook and worksheet protection
in Excel can be cracked before you even have time to say the word. So I
wouldn't put any real sensitive data in any spreadsheet. If not it's under
tools>protection>protect sheet


--


Regards,


Peo Sjoblom

 

[Gord Dibben]

If you want the sheet hidden and not available use Tools>Protection>Protect
Workbook after hiding the sheet.

But note Peo's caveat about Excel internal security.


Gord Dibben MS Excel MVP