Microsoft KB Archive/257452

Knowledge Base

XL2000: Multiple Euro Icons or "Subscript out of Range" Error When You Start Excel

Article ID: 257452

Article Last Modified on 11/5/2003

---

APPLIES TO

• Microsoft Excel 2000 Standard Edition

---

This article was previously published under Q257452

SYMPTOMS

When you start Microsoft Excel, you may see one of the following symptoms:

• You see more than one Euro formatting button on the Formatting toolbar. -or-
  
  
• You receive the following Microsoft Visual Basic error message:

  Run-time error '9':
  Subscript out of range

CAUSE

This behavior occurs when you do the following:

• You start Excel, click Add-ins on the Tools menu, click Euro Currency Tools, and click OK to install the Euro Currency Tools add-in.
  

-and-

• You do one of the following:
  

• • You customize the Formatting toolbar and move the euro formatting button to a new location.
    

-or-

• • You customize the Formatting toolbar so that it has fewer than 10 buttons.

RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

MORE INFORMATION

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

For more information about Microsoft Excel 2000 Euro Currency Tools, click Microsoft Excel Help on the Help menu, type euro in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about Microsoft Excel add-ins, click Microsoft Excel Help on the Help menu, type add-in programs for Microsoft Excel in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: OFF2000 dollars european symbol money format

Keywords: kbbug kbfix KB257452

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.