Not clear what you want to do.

There are 3 levels of protection in Excel......4 if you count VBA project
protection.

1. File open protection. Requires a password to open the file. FileSave
AsToolsGeneral OptionsPassword to open is set here.

2. Workbook protection to protect structure and windows. Password to remove
can be set under ToolsProtectionProtect Workbook.

3. Worksheet protection to prevent sheet changes. Password to remove can be
set ynder ToolsProtectionProtect Worksheet.

Which of these do you want to set?


Gord Dibben MS Excel MVP

On Thu, 14 Sep 2006 21:09:02 -0700, West wrote: