Microsoft Office Tutorials and References
In Depth Information
Protecting workbooks and worksheets
13
Click Accept to keep the change and display the next change.
14
Click Accept to keep the change and delete the History worksheet. The Accept or
Reject Changes dialog box closes.
CLEAN UP Close the ProjectionChangeTracking workbook, saving your changes if
you want to.
Protecting workbooks and worksheets
Excel gives you the ability to share your workbooks over the web, over a corporate intranet,
or by creating copies of files for other users to take on business trips. An important part of
sharing files, however, is ensuring that only those users who 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 that 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.
Search JabSto ::




Custom Search