XL98: Run-Time Errors Running Macro Created in Non-English Excel

ID: Q185020

The information in this article applies to:

SYMPTOMS

When you run a Visual Basic for Applications macro in Microsoft Excel 98 Macintosh Edition, you receive run-time errors.

CAUSE

This problem occurs if the Visual Basic for Applications macros were originally created in a non-English version of Excel.

WORKAROUND

To work around this problem, copy the code into a new workbook. To do this, follow these steps: 

 1. Click the New button on the Standard toolbar to create a new workbook.

 2. Start the Visual Basic Editor (press OPTION+F11).

 3. Click Project Explorer on the View menu.

 4. In the Project Explorer, click the non-English workbook.

 5. Click the triangle next to Modules.

    A list of module sheets in the non-English file is displayed.

 6. Double-click one of the module sheet.

    A module sheet is activated.

 7. On the Edit menu, click Select All.

 8. On the Edit menu, click Copy.

 9. Switch to the Project Explorer (press COMMAND+R).
10. In the Project Explorer window, click the new workbook that you 
    created in step 1.
11. On the Insert menu, click Module.

12. On the Edit menu, click Paste. 

    Repeat steps 6 through 12 for each module sheet in the workbook.
After you copy all of the Visual Basic code into a new workbook, the code is run with fewer errors. How well the code is run from another workbook depends on the assumptions that are made in the code.

Additional query words: XL98 

Keywords          : kbdta xlvbainfo OffVBA xlmac 
Version           : MACINTOSH:98
Platform          : MACINTOSH
Issue type        : kbprb

Last Reviewed: May 3, 1998