Note The features in Microsoft Excel related to hiding
data and protecting worksheets and workbooks with
passwords are not intended to be mechanisms for securing
data or protecting confidential information in Excel. You
can use these features to present information more clearly
by hiding data or formulas that might confuse some users.
These features also help prevent other users from making
accidental changes to data. Excel doesn't encrypt data
that is hidden or locked in a workbook. With enough time,
users can obtain and modify all the data in a workbook, as
long as they have access to it. To help prevent
modification of data and to help protect confidential
information, limit access to any Excel files containing
such information by storing them in locations available
only to authorized users.
Worksheet protection You can protect elements on a
worksheet¡X such as cells with formulas¡X from all user
access, or you can grant individual users access to the
ranges you specify.
Workbook-level protection You can apply protection to
workbook elements and you can protect a workbook file from
viewing and changes. If a workbook is shared (shared
workbook: A workbook set up to allow multiple users on a
network to view and make changes at the same time. Each
user who saves the workbook sees the changes made by other
users. You must have Excel 97 or later to modify a shared
workbook.) you can protect it from being returned to
exclusive use and prevent the change history (change
history: In a shared workbook, information that is
maintained about changes made in past editing sessions.
The information includes the name of the person who made
each change, when the change was made, and what data was
changed.) from being deleted.