| Sometimes we have entered some secret content in excel sheets. To allow only authorized reviewers to modify your content you can set password for it. |
1. Open the Excel workbook file. 2. Goto -> File -> Save As 3. A small window will open. Click onto Tools. 4. Goto General Options. 5. Then a small window named Save Options will open. 6. Enter the area in Password to open and Click OK. 7. In Confirm Password screen, type the password again in Reenter password to proceed area, then click OK. 8. Password has been set to Excel Workbook. The next time someone tries to open the Excel workbook they get this prompt. If a password was set for Password to modify, in addition to Password to open, you will also see the following prompt to Enter password for write access, or read only. Enter the 'modify' password in Password area, then Click OK. |
No comments:
Post a Comment