There are several types of protection.

1. Password to open the file. Can be set at FileSave AsToolsGeneral
Options.

2. Password on a protected worksheet. This is set at ToolsProtectionProtect
Sheet.

Many functions can be disabled using this type of protection.

3. Workbook Protection password. This is set at ToolsProtectionProtect
Workbook.

This protects the workbook from having sheets deleted and other functions
disabled.

4. VBA Project password to prevent viewers from looking at code modules.

NOTE: except for File to Open protection and VBA project passwords, most forms
of Excel protection are very weak and passwords can be easily cracked.


Gord Dibben MS Excel MVP

On Wed, 14 Jun 2006 10:08:21 -0500, GGanders
wrote:


I know you can pass protect a spreadsheet but does anyone know a way I
can pass protect a tab instead of the entire spreadsheet?

Gord Dibben MS Excel MVP