• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11.  Working with Others > Save Options & Password Protection

Save Options & Password Protection

Excel's save options enable you to set up passwords to prevent a document from being opened or from being modified.

To set save options

1.
Choose File > Save As (Figure 1).

2.
In the Save As dialog box that appears (Figure 35), click the Options button.

Figure 35. The Save As dialog box.


3.
Set options in the Save Options dialog box (Figure 36) as desired:

Figure 36. Use the Save Options dialog box to set all kinds of options for protecting a file.


  • Always create backup tells Excel to save the previous version of the file as a backup when saving the current version. (The old file is named "Backup of filename".)

  • Password to open is the password that must be entered in order to open the file.

  • Password to modify is the password that must be entered in order to save changes to the file.

  • Read-only recommended tells Excel to recommend that the file be opened as a read-only file when the user tries to open it.

4.
Click OK.

5.
If you entered a password in step 3, a dialog box like the one in Figure 25 appears, asking you to confirm it. Reenter the password and click OK. (If you entered two passwords, this dialog box appears twice.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint