Protection Open and Modify Workbook in Excel

When saving a workbook, you can protect the workbook so that can not be opened or modified in any person. To open or modify the workbook, the user must enter the appropriate password.

Please see the following ropes:
 1. Click the Office Button menu and then Select Save to save the new workbook, or Save As to save the workbook with a different name. Will display the Save As dialog box.

2. Click the drop down button and select the menu Tools General Options.

 
3. Appears General Options dialog box. To protect the workbook can not be opened so that any person, enter the password in the Password to open text box:

4. To protect a workbook that can not be modified any person, enter the password in the password text box to modify: Press the OK button.

 
5. Confirm Password dialog box appears. Enter the password used to protect open workbook. Press the OK button.

6. Confirm Password dialog box appears. Enter the password used to protect modification workbook. Press the OK button.

7. Save As dialog box appearing. Type a file name in the File name text box: and then press the Save button. Each open workbook protected, Password dialog box appears as shown below.

 
8. At the prompt Password:, type the password you will enter when protecting the workbook. Press the OK button.

9. If you are using correct password, the password dialog box appears to open the workbook protection modifications.

10. At the prompt Password: type the password that you enter when protecting the workbook. Press the OK button. If you enter the correct password, workbook modifications can be made.

11. If you forget the password used to protect, press the Read Only to open the workbook. If there is a change in the contents of the workbook, save the workbook with a different name.

So first a brief description of my protection and Modified Open Workbook in Excel. May be useful for you. And that certainly saay will give the other tutorials on post-post next.