Sheet protection question

[mdnightman]

Is it possible to protect excel sheet with a password such that
without password a user not only cannot modify the sheet but also
cannot view it?

Thanks for any input.

(I'm using excel 2007)

 

[FSt1]

hi
with the file open...on the menu bar, click file>saveas
on the saveas dialog box, click tools>general options...
here you can enter a passwork to open and a password to modify.

Regards
FSt1

 

[mdnightman]

Thanks but that's not what I need.
I don't want to lock the whole file, only some sheets, some other
sheets are still viewable by everyone.

 

[Gord Dibben]

I don't use 2007 but priniciple is the same as earlier versions.

Protect the sheet under Tools>Protection>Protect Sheet.

Format>Hide>Worksheet.

Tools>Protection>Protect Workbook for Windows and Structure.

Note: Excel's internal security is easily broken si don't use this method if it
essential your data is not viewed.

The general rule is......if you don't want anyone to access it......don't
include it in the workbook.