Microsoft Office Tutorials and References
In Depth Information
Keeping Workbooks Secure
Choose the File tab and from the Info section, click
the Protect Workbook button. Choose Mark as
Final. Click OK at the acknowledgement message
that appears. Excel saves the file and displays a
confirmation message. Click OK then click the File
tab to return to the workbook. The words
ReadOnly appear next to the file name on the Title bar
(see Figure 12-7). Also notice that all items on the
Ribbon are grayed out and unavailable.
1. Choose File>Save As, which displays the Save
As dialog box.
2. Click the Tools button and then select
General Options. Excel provides two levels of
password protection. You can use either or
both password options.
3. Type a password in the Password to Open
text box (see Figure 12-8). The Password to
Open box prevents unauthorized users from
even opening the workbook.
Edit Anyway Read-Only
Changes cannot be made to a file marked as final.
Marking the workbook as final disables every
option in the Ribbon that could change the
workbook in any way. The Mark as Final feature is
designed to prevent accidental changes and is not
permanent. If you find you need to make changes
to the workbook, click the Edit Anyway button.
Assigning a File Password
Another method to protect your workbook is
applying a password to keep others from even opening
the workbook. You can also apply a password to
allow them to view it but not make any changes,
anywhere in the entire workbook. This type of
password protection, called file-level protection, is
accomplished through the Save As dialog box.
Follow these steps to assign file-level passwords:
Assigning passwords to protect the file.
4. Optionally, type a password in the Password
to Modify text box. The Password to Modify
box prevents users, once the workbook is
open, from making any changes.