O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Protecting a Worksheet

If you store Excel workbooks only on your own PC, you can control exactly how and when you change the data and structure of each worksheet. In a typical workgroup environment, however, you'll often save a workbook to a shared folder on your company's network. How do you maintain the confidentiality of sensitive data? And how do you allow co-workers to view the contents of a workbook without changing crucial data or formulas, either deliberately or by accident?

If you must store sensitive workbook files in shared network folders that are accessible to everyone, lock them up with passwords. Excel lets you create two levels of access to limit an unauthorized user's ability to opening or modifying a workbook. For finer control ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required