1.

What Types Of Workbook Protection Are Available?

Answer»

Excel provides three ways to protect a workbook:

  • Require a PASSWORD to open the workbook.
  • Prevent USERS from adding sheets, deleting sheets, HIDING sheets, and unhidingsheets.
  • Prevent users from changing the SIZE or position of windows.

To protect protect a workbook you can activate the workbook to be protected, then choose Tools - Protection - Protect Sheet. You will be asked to provide a password (optional).If you do provide a password, that password will be required to UNPROTECT the workbook.

Excel provides three ways to protect a workbook:

To protect protect a workbook you can activate the workbook to be protected, then choose Tools - Protection - Protect Sheet. You will be asked to provide a password (optional).If you do provide a password, that password will be required to unprotect the workbook.


Discussion

No Comment Found

Related InterviewSolutions