Apply a Password to Parts of a Worksheet : Workbook Password « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Workbook Worksheet
  3. Workbook Password
Select the range. 
           Click the Review tab. 
           Click the Allow Users to Edit Ranges button.
Select the range. Click the Review tab. Click the Allow Users to Edit Ranges button.
Click New.
Click New.
Select a range.
To modify or delete a range, click a range, and then click Modify or Delete.
Type a range password. Click OK.
Type a range password. Click OK.
Retype the password. Click OK.
Retype the password. Click OK.
To modify or delete a range, 
           click a range, and then click Modify or Delete.
To modify or delete a range, click a range, and then click Modify or Delete.
Click OK.
Click OK.








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