when you password protect the excel file, you can do this for two options , one pasword for OPEN and one for MODIFY.
Protecting the File
- From the File menu, select Save As...The Save As dialog box appears.
- From the Tools pull-down list, select General Options...
The General Options dialog box appears.
- in the Password to open text box, type a password
in the Password to modify text box, type a password
- OPTIONAL: If you like Excel to recommend that this file be opened as a read-only file each time it is opened, select Read-only recommended
- Click OKThe Confirm Password dialog box appears.
- In the Reenter password to modify text box, type the password(s) in the order of the password(s) that you typed in the Save Options dialog box
- Click OK
- Click SAVE
Unprotecting the File
If you no longer need to password-protect the file, you can remove the password.
- Open the file
- From the File menu, select Save As…
- In the Save As dialog box, from the Tools pull-down list, select General Options...
- In the Password to open text box, select the text » press [Delete]
- In the Password to modify text box, select the text » press [Delete]
- Click OKThe file is no longer password protected.
- To save the file, click SAVE
- Click YES
No comments:
Post a Comment