Microsoft Office Tutorials and References
In Depth Information
Protecting the workbook
When you click New in the Allow Users To Edit Ranges dialog box to add a cell range to the
list, the New Range dialog box appears, as shown in Figure 6-26. Type a title for the range
of cells you want to allow users to edit. Type a cell range or range name in the Refers To
Cells box, or click in the box and drag through the range you want to specify.
Figure 6-26 Use the New Range dialog box to specify ranges you want to allow users to edit.
Selecting the Paste Permissions Information Into A New Workbook check box in the Allow
Users To Edit Ranges dialog box is a handy way to keep track of who and what you
specified in the Permissions list. Note that you can click the Protect Sheet button for quick access
to the Protect Sheet dialog box shown earlier in Figure 6-22. You can click the Permissions
button to specify individuals who are allowed to edit each range. When you do so, a dialog
box like the one shown in Figure 6-27 appears.
Figure 6-27 Set permissions for individual users by clicking Permissions in the Allow Users To
Edit Ranges dialog box.