Microsoft Office Tutorials and References
In Depth Information
Protecting the workbook
The Permissions dialog box lists all the users who are authorized to edit the worksheet, as
well as whether they need to use a password to do so. For each item in the Group Or User
Names list, you can specify password permissions in the box; click Allow or Deny to restrict
editing without a password. This lets you, in effect, employ two levels of restriction, because
you are restricting editing access to specified users anyway, and you can force even those
users to type a password if you want to do so.
You must specify a password in the New Range dialog box (shown in Figure 6-26) or in
the identical Modify Range dialog box to turn on the permissions options that you set.
If you don’t specify a range password, anyone can edit the range.
You can add users and groups to the list in the Permissions dialog box by clicking Add and
then clicking Advanced to display the full dialog box shown in Figure 6-28. Click Find Now
to locate all the users and groups available to your system. However, if you are connected
to a large network, this might take a long time, so you can use the Common Queries area
to restrict your search. You can also use the Object Types and Locations buttons to restrict
your search further. After you click Find Now, you can select items in the list at the bottom
of the dialog box that you want to add. Press the Ctrl key to select multiple items. When
you have located the users and groups you want to add, click OK.
To add or change users on your computer, open User Accounts in Control Panel.
Remember, after all this, you still have to activate worksheet protection by clicking Protect
Sheet on the Home tab or by clicking Protect Sheet in the Allow Users To Edit Ranges
For information about Excel and networks, see “Sharing workbooks on a network” in