S
Stephen White
From help type protect.
About worksheet and workbook protection
Microsoft Excel provides several layers of protection to control who can access and change your Excel data:
Worksheet protection You can protect elements on a worksheet — such as cells with formulas — from all user access, or you can grant individual users access to the ranges you specify.
Workbook-level protection You can apply protection to workbook elements and you can protect a workbook file from viewing and changes. If a workbook is shared (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users. You must have Excel 97 or later to modify a shared workbook.) you can protect it from being returned to exclusive use and prevent the change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.) from being deleted.
Protecting worksheet elements
Protecting elements from all users You can prevent users from inserting, deleting, and formatting rows and columns, from changing the contents of locked cells, and from moving the cursor to cells that are locked or to cells that are unlocked.
By default all cells on a worksheet are locked. Before you protect a worksheet, you can unlock cells where you want users to enter and change data, in two ways. To unlock cells for all users, you can use the Protection tab of the Format Cells dialog box. To unlock cells for specific users, you can use the Allow Users to Edit Ranges dialog box. Any ranges that you specify in this dialog box and don't assign a password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) for are also unlocked for all users. The cells you leave locked become protected only after you protect the worksheet.
Other worksheet features and elements for which you can restrict access for all users include hyperlinks (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, an HTML page on the World Wide Web, or an HTML page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.), sorting, AutoFiltering, PivotTable reports (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources including ones external to Excel.), graphic objects, and scenarios (scenario: A named set of input values that you can substitute in a worksheet model.). These protections apply to all users and the entire worksheet, not to individual users or data ranges.
For chart sheets, you can protect the contents of the chart from changes, and you can protect any graphic objects on the sheet, such as text boxes, from being changed or deleted. A protected chart sheet continues to be updated whenever the source data for the chart changes.
Giving specific users access to protected ranges If you have the Windows 2000 operating system, you can allow specific users to edit specific cells or ranges. Users to whom you grant access can edit the cells even if the cells are locked. Your access restrictions take effect only after you protect the worksheet.
The users you specify in the Permissions for range dialog box can automatically edit the range without entering the password. Other users are prompted for the password, and users who enter the password can then edit the range. If a cell belongs to more than one range, users who are authorized to edit any of the ranges can then edit the cell. If a user attempts to edit multiple cells at once and is authorized to edit some but not all of those cells, the user will be prompted to select and edit the cells one by one.
Protecting workbook elements and files
Protecting workbook elements You can prevent users from adding or deleting worksheets, or displaying hidden worksheets. You can also prevent users from changing the sizes or positions of the windows you set up to display a workbook. These protections apply to the entire workbook.
To hide an entire workbook so that users can't see it but can gain access to contents such as macros (macro: An action or a set of actions you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.), use the Hide command on the Window menu, and then save the hidden workbook.
Protecting a shared workbook You can protect a shared workbook so that users cannot return it to exclusive use or delete the change history log. If you want to require a password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) to remove this type of protection, you must apply the protection before you share the workbook. Applying the protection automatically turns on sharing. Unprotecting these features turns off sharing and deletes all of the saved change history.
Alternatively, you can protect the sharing and change history without a password. You can apply this protection when a workbook is already shared, and then unprotecting won't turn off sharing or delete the change history.
Protecting a workbook file from viewing and editing You can restrict who can open and use the data in a workbook file by requiring a password to view or save changes to the file. You can set two separate passwords, one that users must enter to open and view the file, and another that users must enter before they can edit and save changes to the file. These passwords apply to the workbook file and are separate from the protection provided by the Protect Workbook dialog box.
About worksheet and workbook protection
Microsoft Excel provides several layers of protection to control who can access and change your Excel data:
Worksheet protection You can protect elements on a worksheet — such as cells with formulas — from all user access, or you can grant individual users access to the ranges you specify.
Workbook-level protection You can apply protection to workbook elements and you can protect a workbook file from viewing and changes. If a workbook is shared (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users. You must have Excel 97 or later to modify a shared workbook.) you can protect it from being returned to exclusive use and prevent the change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.) from being deleted.
Protecting worksheet elements
Protecting elements from all users You can prevent users from inserting, deleting, and formatting rows and columns, from changing the contents of locked cells, and from moving the cursor to cells that are locked or to cells that are unlocked.
By default all cells on a worksheet are locked. Before you protect a worksheet, you can unlock cells where you want users to enter and change data, in two ways. To unlock cells for all users, you can use the Protection tab of the Format Cells dialog box. To unlock cells for specific users, you can use the Allow Users to Edit Ranges dialog box. Any ranges that you specify in this dialog box and don't assign a password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) for are also unlocked for all users. The cells you leave locked become protected only after you protect the worksheet.
Other worksheet features and elements for which you can restrict access for all users include hyperlinks (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, an HTML page on the World Wide Web, or an HTML page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.), sorting, AutoFiltering, PivotTable reports (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources including ones external to Excel.), graphic objects, and scenarios (scenario: A named set of input values that you can substitute in a worksheet model.). These protections apply to all users and the entire worksheet, not to individual users or data ranges.
For chart sheets, you can protect the contents of the chart from changes, and you can protect any graphic objects on the sheet, such as text boxes, from being changed or deleted. A protected chart sheet continues to be updated whenever the source data for the chart changes.
Giving specific users access to protected ranges If you have the Windows 2000 operating system, you can allow specific users to edit specific cells or ranges. Users to whom you grant access can edit the cells even if the cells are locked. Your access restrictions take effect only after you protect the worksheet.
The users you specify in the Permissions for range dialog box can automatically edit the range without entering the password. Other users are prompted for the password, and users who enter the password can then edit the range. If a cell belongs to more than one range, users who are authorized to edit any of the ranges can then edit the cell. If a user attempts to edit multiple cells at once and is authorized to edit some but not all of those cells, the user will be prompted to select and edit the cells one by one.
Protecting workbook elements and files
Protecting workbook elements You can prevent users from adding or deleting worksheets, or displaying hidden worksheets. You can also prevent users from changing the sizes or positions of the windows you set up to display a workbook. These protections apply to the entire workbook.
To hide an entire workbook so that users can't see it but can gain access to contents such as macros (macro: An action or a set of actions you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.), use the Hide command on the Window menu, and then save the hidden workbook.
Protecting a shared workbook You can protect a shared workbook so that users cannot return it to exclusive use or delete the change history log. If you want to require a password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) to remove this type of protection, you must apply the protection before you share the workbook. Applying the protection automatically turns on sharing. Unprotecting these features turns off sharing and deletes all of the saved change history.
Alternatively, you can protect the sharing and change history without a password. You can apply this protection when a workbook is already shared, and then unprotecting won't turn off sharing or delete the change history.
Protecting a workbook file from viewing and editing You can restrict who can open and use the data in a workbook file by requiring a password to view or save changes to the file. You can set two separate passwords, one that users must enter to open and view the file, and another that users must enter before they can edit and save changes to the file. These passwords apply to the workbook file and are separate from the protection provided by the Protect Workbook dialog box.