Microsoft Office Tutorials and References
In Depth Information
If you work in an environment in which you and your colleagues, both inside and outside
your organization, exchange files frequently, you can use a digital signature to help verify
that your workbooks and any macros they contain are from a trusted source.
Finally, if you want to display information on a Web site, you can do so by saving a
workbook as a Web page. Your colleagues won’t be able to edit the workbook, but they will
be able to view it and comment by e-mail or phone.
In this chapter, you’ll learn how to share a workbook, manage comments in workbook
cells, track and manage changes made by colleagues, protect workbooks and
worksheets, digitally sign your workbooks, and save your workbooks for the Web.
Practice Files Before you can complete the exercises in this chapter, you need to copy
the book’s practice files to your computer. The practice files you’ll use to complete the
exercises in this chapter are in the Chapter14 practice file folder. A complete list of
practice files is provided in “Using the Practice Files” at the beginning of this topic.
To enable several users to edit a workbook simultaneously, you must turn on workbook
sharing. Workbook sharing is perfect for an enterprise such as Consolidated Messenger,
whose employees need to look up customer information, shipment numbers, and details
on mistaken deliveries.
To turn on workbook sharing, on the Review tab, in the Changes group, click Share
Workbook. On the Editing page of the Share Workbook dialog box, turn on workbook
sharing by selecting the Allow Changes By More Than One User At The Same Time
check box. You can then set the sharing options for the active workbook by clicking the