Microsoft Office Tutorials and References
In Depth Information
13. Click Accept .
Excel keeps the change and then displays the next change.
14. Click Accept .
Excel keeps the change and deletes the History worksheet. The Accept Or Reject
Changes dialog box closes.
CLEAN UP Save the ProjectionChangeTracking workbook, and then close it.
Protecting Workbooks and Worksheets
Excel gives you the ability to share your workbooks over the Web, over a corporate intranet,
or by copying files for other users to take on business trips. An important part of sharing
files, however, is ensuring that only those users you want to have access to the files can
open or modify them. For example, Consolidated Messenger might have a series of
computers available in a processing center so supervisors can look up package volumes and
handling efficiency information. Although those computers are vital tools for managing
the business process, it doesn’t help the company to have unauthorized personnel, even
those with good intentions, accessing critical workbooks.
You can limit access to your workbooks or elements within workbooks by setting passwords.
When you set a password for an Excel workbook, any users who want to access the protected
workbook must enter the workbook’s password in a dialog box that opens when they try to
open the file. If users don’t know the password, they cannot open the workbook.
To set a password for a workbook, open the workbook to be protected, and click the File
tab to display the workbook in the Backstage view. Then, on the Info page of the Backstage
view, click the Protect Workbook button and then click Encrypt With Password. The Encrypt
Document dialog box opens, with a Password box in which you can type your password. After
you click OK, the Confirm Password dialog box opens, in which you can verify the password
required to open the workbook. After you have confirmed the password, click OK. Now the
Info page of the Backstage view indicates that users must enter a password to open the file.