Excel Protection

[matt2020]

Can you protect a sheet inside of a excel document so that it can't be edited or even viewed.

Ex.

Sheet 1 --- every one can view, read and edit
Sheet 2 --- every one can view, read and edit
Sheet 3 --- you cant even view unless you use a password

Any suggestions would help!!!

Thanks,

 

[Jaafar Tribak]

Format=>Sheet=>Hide

Regards.

 

[Oaktree]

To take Jaafar's suggestion a step further, you could also use tools --> protection --> protect workbook --> structure to require a password to change the structure (such as unhiding sheets).

Realize, however, that the tools --> protection options are really more like "tools --> deterrence" options, as there are several programs available to hack those passwords if the user is that devoted.