You specify a password to protect others from opening the workbook. When users try to open a workbook that has a password assigned then they will be prompted to enter the password in order to view the contents of the workbook. Perform the following steps to assign password to a workbook:
1. Open the Microsoft Excel file to specify a password.
2. Click File menu and click Info.
3. Click Protect Workbook and click Encrypt with Password to open the Encrypt Document dialog box.
4. Enter the password and click OK.
5. Confirm the password by entering the same password again.
Now, when you open the workbook, you will be prompted to enter the password.
Tuesday, February 23, 2010
Subscribe to:
Post Comments (Atom)
