• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 16. Collaborating with Colleagues > Protecting Workbooks and Worksheets

Protecting Workbooks and Worksheets

Excel gives you the ability to share your workbooks over the Web, via a corporate intranet, and by copying files for other users to take with them 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, The Garden Company might have a series of computers available on the sales floor so that sales associates can look up prices and inventory information. While those computers are vital tools in making sales, it wouldn’t help the company to have customers, even those with good intentions, accessing critical workbooks.


You can limit access to your workbooks, or elements within a workbook, by setting passwords. Setting a password for an Excel workbook means that any users who want to access the protected workbook must enter the workbook’s password in a dialog box that appears when they try to open the file. If the person doesn’t know the password, he or she will be unable to open the workbook.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint