Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

This article was previously published under Q283665

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Keywords: KB283665, kbprb

↑ Back to the top

Article Info
Article ID : 283665
Revision : 7
Created on : 5/21/2007
Published on : 5/21/2007
Exists online : False
Views : 542