Microsoft KB Archive/282147

= XL2002: Multiple Ranges Contain the Same Title =

Article ID: 282147

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q282147





SYMPTOMS
When you attempt to specify edit ranges to allow users access to parts of a protected worksheet, some of the ranges may unexpectedly have the same title.



CAUSE
This behavior can occur if the ranges were renamed with a Microsoft Visual Basic for Applications subprocedure. No error message is generated when a range is renamed to the same title as an existing range by using the Visual Basic for Applications AllowEditRanges property.



WORKAROUND
To work around this issue, follow these steps:
 * 1) Start Excel.
 * 2) Open the workbook.
 * 3) If the sheet is protected, on the Tools menu, click Protection, click Unprotect Sheet, type the password, and then click OK.
 * 4) On the Tools menu, click Protection, and then click Allow Users to Edit Ranges.
 * 5) Select an edit range that has a duplicate title, click Modify, change the title, and then click OK. Repeat this step until all the edit ranges have unique titles.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2002

Keywords: kbbug kbpending KB282147

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.