XL2002: Password Required to Edit a Range Protected with NT Permissions (283665)

SYMPTOMS

When you use the Allow Users to Edit Ranges feature to specify that a user may edit a protected range, that user is prompted for a password if he or she tries to edit a protected range.

CAUSE

This behavior occurs when the following conditions are true:

In the Allow Users to Edit Ranges dialog box, you use Microsoft Windows NT permissions to allow users to edit a range without a password.

-and-
One of the users who is allowed to make changes opens the workbook in an operating system other than Microsoft Windows 2000 or Microsoft Windows NT.

-and-
The user attempts to change a cell within the protected range.

MORE INFORMATION

In Windows 2000 or Windows NT, Excel workbooks can use edit permissions based upon users or groups, instead of passwords, to restrict access to ranges within workbooks. In Microsoft Windows 95, Microsoft Windows 98, and Microsoft Windows Millennium Edition (Me), this option is not available.

If you are running Windows 2000, you can add user or group permissions to specified ranges in the Allow Users to Edit Ranges dialog box in Excel. To view this dialog box, point to Protection on the Tools menu, and then click Allow Users to Edit Ranges.

Excel 2002 uses the Select User, Computers, or Groups dialog box from Windows 2000, which is not available on other operating systems such as Windows NT, Windows 98, and Windows Me.

REFERENCES

For more information about worksheet protection, click Microsoft Excel Help on the Help menu, type about worksheet protection in the Office Assistant or the Answer Wizard, and then click Search to view the topic.