Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Sharing Your Work with the Outside World
Figure 19-3: A password is now needed to make changes to the file.
Note that Excel passwords are case-sensitive, so make sure Caps Lock on your keyboard
is in the off position when entering your password.
Tip
Requiring a password to open an Excel file
You may have instances where your Excel dashboards are so sensitive only certain users are
authorized to see them. In these cases, you can require your workbook to receive a password to open
it. Here are the steps to set up a password for the file:
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 (refer to
Figure 19-1).
The General Options dialog box opens.
4. Type an appropriate password in the Password to Open text box (as shown in Figure 19-4)
and click OK.
5. Excel asks you to reenter your password.
6. Save your file to a new name.
At this point, your file is password protected from unauthorized viewing.
Figure 19-4: Type the password needed to modify the file.
Removing workbook-level protection
Removing workbook-level protection is as easy as clearing the passwords from the General Options
dialog box. Here’s how you do it:
1. With your file open, click the File tab.
Search JabSto ::




Custom Search