Protect workbook elements. : Workbook Password « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Workbook Worksheet
  3. Workbook Password
Click the Review tab, click the Protect Workbook button
Click the Review tab, click the Protect Workbook button
Select or clear the Structure or Windows check boxes.
Select or clear the Structure or Windows check boxes.
Select the Structure check box to prevent users from viewing, 
           copying, moving, or inserting worksheets.
Select the Structure check box to prevent users from viewing, copying, moving, or inserting worksheets.
Select the Windows check box to prevent users from moving, resizing, or closing windows.
Select the Windows check box to prevent users from moving, resizing, or closing windows.








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