Microsoft KB Archive/93345

{|
 * width="100%"|

Excel: Adding Sheet to Workbook Removes Password

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 4.0
 * Microsoft Excel for the Macintosh, version 4.0

-

SUMMARY
A password-protected document that is added to a workbook as a bound sheet will not retain its password protection. However, unbound sheets will retain their password protection.

MORE INFORMATION
When a sheet is protected, the only way to remove the password is to delete the password from the Options dialog box (from the File menu, choose Save As and choose the Options button).

However, when you add a password-protected document as a bound sheet to a workbook, the password is removed after the file is added and the user is prompted to enter the password. To protect a bound sheet in a workbook with a password, you must protect the entire workbook with a password when you save the workbook. You cannot password protect a bound sheet separately from the workbook.