Sheet protection question
 

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)

Sheet protection question
 

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

Regards
FSt1


" wrote:

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)

Sheet protection question
 

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.


On Dec 28, 2:04 pm, FSt1 wrote:
hi
with the file open...on the menu bar, click filesaveas
on the saveas dialog box, click toolsgeneral options...
here you can enter a passwork to open and a password to modify.

Regards
FSt1

Sheet protection question
 

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

Protect the sheet under ToolsProtectionProtect Sheet.

FormatHideWorksheet.

ToolsProtectionProtect 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.




On Fri, 28 Dec 2007 13:27:30 -0800 (PST), wrote:

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.


On Dec 28, 2:04 pm, FSt1 wrote:
hi
with the file open...on the menu bar, click filesaveas
on the saveas dialog box, click toolsgeneral options...
here you can enter a passwork to open and a password to modify.

Regards
FSt1