Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Sharing Your Work with the Outside World
➤ Forcing read-only access to a file until a password is given
➤ Requiring a password to open an Excel file
➤ Removing workbook-level protection
The next few sections discuss these options in detail.
Permitting read-only access unless a password is given
You can force your workbook to go into read-only mode until the user types the password. This way,
you can keep your file safe from unauthorized changes yet still allow authorized users to edit the file.
Here are the steps to force read-only mode:
1. With your file open, click the File tab.
2. To open the Save As dialog box, select Save As and then double-click the Computer icon.
3. In the Save As dialog box, click the Tools button and select General Options (see Figure 19-1).
The General Options dialog box appears.
4. Type an appropriate password in the Password to Modify input box (see Figure 19-2) and
5. Excel asks you to reenter your password, so reenter your chosen password.
6. Save your file to a new name.
At this point, your file is password protected from unauthorized changes. If you were to open
your file, you’d see something similar to Figure 19-3. Failing to type the correct password
causes the file to go into read-only mode.
Figure 19-1: The File Sharing options are well hidden away in the Save As dialog box under General Options.
Figure 19-2: Type the password needed to modify the file.