Add Password Protection to a Workbook : Workbook Password « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Workbook Worksheet
  3. Workbook Password
Click the Office button, and then click Save As.
Click the Office button, and then click Save As.
Click Tools, and then click General Options.
Click Tools, and then click General Options.
Type a password in the Password to open box or the Password to modify box.
Type a password in the Password to open box or the Password to modify box.
Select or clear the Always create backup check box.
Select or clear the Always create backup check box.
Select or clear the Read-only recommended check box.
Select or clear the Read-only recommended check box.
Click OK.
Click OK.
Type your password again.  Click OK.
Type your password again. Click OK.
Click Save.
Click Save.








7.7.Workbook Password
7.7.1.Add Password Protection to a WorkbookAdd Password Protection to a Workbook
7.7.2.Open a Workbook with Password ProtectionOpen a Workbook with Password Protection
7.7.3.Change or Remove the Password ProtectionChange or Remove the Password Protection
7.7.4.Apply a Password to a WorksheetApply a Password to a Worksheet
7.7.5.Protect workbook elements. Protect workbook elements.
7.7.6.Apply a Password to Parts of a WorksheetApply a Password to Parts of a Worksheet
7.7.7.Unprotect a worksheet or workbookUnprotect a worksheet or workbook