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

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

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.

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:

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.

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.