Frequently asked questions about workbook protection in Excel (293445)
The information in this article applies to:
- Microsoft Office Excel 2003
- Microsoft Excel 2002
This article was previously published under Q293445 SUMMARY
Microsoft Excel provides multiple layers of protection to allow you to control who can access and change your data:
- Worksheet protection: You can protect elements on a worksheet (for example, cells with formulas) from all user access, or you can grant individual users access to the ranges that you specify.
- Workbook-level protection: You can apply protection to workbook elements, and you can protect a workbook file from being viewed and edited. If a workbook is shared, you can protect it from being returned to exclusive use and prevent the change history from being deleted.
REFERENCES
For more information about workbook protection, click Microsoft Excel Help on the
Help menu, type about workbook protection in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Minor | Last Reviewed: | 1/6/2006 |
---|
Keywords: | kbhowto kbinfo KB293445 |
---|
|