Hi,

Is it possible to have a password to open up an excel spreadsheet?

Thanks

Jeff

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 Thu, 21 Dec 2006 14:26:02 -0800, Jeff wrote:

Hi,

Is it possible to have a password to open up an excel spreadsheet?

Thanks

Gord Dibben MS Excel MVP