Question

Explain three different ways you protect your workbook in MS EXCEL 2007

Answer 1

el 2007 includes a Protect Workbook command that prevents others from making changes to the layout of the worksheets in a workbook. You can assign a password when you protect a workbook so that only those who know the password can unprotect the workbook and make changes to the structure and layout of the worksheets.

Protecting a workbook does not prevent others from making changes to the contents of cells. To protect cell contents, you must use the Protect Sheet command button on the Review tab.

Click the Protect Workbook command button in the Changes group on the Review tab.
Excel opens the Protect Structure and Windows dialog box, where the Structure check box is selected by default. With the Structure check box selected, Excel won’t let anyone mess around with the sheets in the workbook (by deleting them or rearranging them).

You can protect the structure and windows in a workbook.
(Optional) If you want to protect any windows that you set up, select the Windows check box.
When selected, this setting keeps the workbook windows in the same size and position each time you open the workbook.
To assign a password that must be supplied before you can remove the protection from the worksheet, type the password in the Password (optional) text box.
Click OK.
If you typed a password in the Password (optional) text box, Excel opens the Confirm Password dialog box. Re-enter the password in the Reenter Password to Proceed text box exactly as you typed it Step 3, and then click OK.