Excel Protection

matt2020

New Member
Joined
Dec 22, 2005
Messages
1
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,
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,529
Messages
5,572,655
Members
412,481
Latest member
nhantam
Top