Microsoft KB Archive/283665

= XL2002: Password Required to Edit a Range Protected with NT Permissions =

Article ID: 283665

Article Last Modified on 5/21/2007

-

APPLIES TO

 Microsoft Excel 2002 Standard Edition, when used with:  Microsoft Windows 98 Standard Edition

 Microsoft Windows 98 Second Edition

 Microsoft Windows Millennium Edition 

-

<div class="notice_section">

This article was previously published under Q283665

<div class="symptoms_section">

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.

<div class="cause_section">

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.

<div class="moreinformation_section">

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.

<div class="references_section">