Microsoft Office Tutorials and References
In Depth Information
Marking a Workbook as Final
4. Type a password in the Password box.
Passwords are case-sensitive.
The workbook remains open so you can continue
to work on it. However, after you close it, when
you open it again, you are prompted to enter
your password, as shown in Figure 13-10. Do
so and click OK. The workbook is opened and
unless other protections are in place, you can
make any changes you want.
5. Click OK.
6. The Confirm Password dialog box appears
and you’re prompted to confirm the
password by retyping it. Type the same password
you typed in Step 4 and click OK.
You must enter a
password to view
Save the workbook to save your changes.
Removing a Password
Make sure you remember this password
because without it, you will not be able
to open the file again.
To remove a password from a workbook,
after opening it, follow these same steps to
open the Encrypt Document dialog box.
Select the password and delete it, and then
click OK. Save the workbook to save your
If you are through making changes to
a workbook but still need to share its contents
with others, you might want to make it “read-
only”. A read-only file is just that—available for
reading (viewing), but not editing. With Excel,
you make a workbook read-only by marking it
Marking a workbook as final only helps to prevent
unwanted changes from your users. They can, if
they are determined, remove the read-only status
from the workbook and make changes anyway.
Still, it’s not an accidental thing, as you will see,
so it’s worth your time and trouble.